2025-03-05 13:58:13 Using queries from '/usr/share/clickhouse-test/queries' directory 2025-03-05 13:58:13 Connecting to ClickHouse server... OK 2025-03-05 13:58:13 Connected to server 24.3.12.76.altinitystable @ da27279116c0c6a39ac94f6f146e5eed531f6b3d HEAD 2025-03-05 13:58:13 Found 1121 parallel tests and 116 sequential tests 2025-03-05 13:58:14 2025-03-05 13:58:14 Running about 140 stateless tests (ForkPoolWorker-6). 2025-03-05 13:58:14 2025-03-05 13:58:14 03215_analyzer_replace_with_dummy_tables: [ OK ] 0.43 sec. 2025-03-05 13:58:14 2025-03-05 13:58:14 Running about 140 stateless tests (ForkPoolWorker-2). 2025-03-05 13:58:14 2025-03-05 13:58:14 03246_range_literal_replacement_works: [ OK ] 0.46 sec. 2025-03-05 13:58:14 2025-03-05 13:58:14 Running about 140 stateless tests (ForkPoolWorker-3). 2025-03-05 13:58:14 2025-03-05 13:58:14 03231_prewhere_conditions_order: [ OK ] 0.50 sec. 2025-03-05 13:58:14 2025-03-05 13:58:14 Running about 140 stateless tests (ForkPoolWorker-8). 2025-03-05 13:58:14 2025-03-05 13:58:14 03210_variant_with_aggregate_function_type: [ OK ] 0.79 sec. 2025-03-05 13:58:14 03196_max_intersections_arena_crash: [ OK ] 0.44 sec. 2025-03-05 13:58:15 03167_parametrized_view_with_cte: [ OK ] 0.45 sec. 2025-03-05 13:58:15 03151_analyzer_view_read_only_necessary_columns: [ OK ] 0.46 sec. 2025-03-05 13:58:15 2025-03-05 13:58:15 Running about 140 stateless tests (ForkPoolWorker-7). 2025-03-05 13:58:15 2025-03-05 13:58:15 03217_json_merge_patch_stack_overflow: [ OK ] 1.64 sec. 2025-03-05 13:58:15 03143_parallel_replicas_mat_view_bug: [ OK ] 0.65 sec. 2025-03-05 13:58:15 03151_redundant_distinct_with_window: [ OK ] 0.71 sec. 2025-03-05 13:58:15 2025-03-05 13:58:15 Running about 140 stateless tests (ForkPoolWorker-9). 2025-03-05 13:58:15 2025-03-05 13:58:15 03209_parameterized_view_with_non_literal_params: [ OK ] 1.82 sec. 2025-03-05 13:58:15 2025-03-05 13:58:15 Running about 140 stateless tests (ForkPoolWorker-4). 2025-03-05 13:58:15 2025-03-05 13:58:15 03221_mutation_analyzer_skip_part: [ OK ] 1.97 sec. 2025-03-05 13:58:15 03130_abs_in_key_condition_bug: [ OK ] 0.67 sec. 2025-03-05 13:58:16 2025-03-05 13:58:16 Running about 140 stateless tests (ForkPoolWorker-5). 2025-03-05 13:58:16 2025-03-05 13:58:16 03217_filtering_in_system_tables: [ OK ] 2.02 sec. 2025-03-05 13:58:16 03127_argMin_combinator_state: [ OK ] 0.56 sec. 2025-03-05 13:58:16 03016_analyzer_groupby_fuzz_59796: [ OK ] 0.44 sec. 2025-03-05 13:58:16 03031_distinguish_bool_and_int_in_settings: [ OK ] 0.83 sec. 2025-03-05 13:58:16 03015_with_fill_invalid_expression: [ OK ] 0.48 sec. 2025-03-05 13:58:16 03022_alter_materialized_view_query_has_inner_table: [ OK ] 0.70 sec. 2025-03-05 13:58:16 03015_analyzer_groupby_fuzz_60772: [ OK ] 0.47 sec. 2025-03-05 13:58:16 03014_group_by_use_nulls_injective_functions_and_analyzer: [ OK ] 0.44 sec. 2025-03-05 13:58:17 03033_scalars_context_data_race: [ OK ] 1.30 sec. 2025-03-05 13:58:17 03013_position_const_start_pos: [ OK ] 0.37 sec. 2025-03-05 13:58:17 03014_window_view_crash: [ OK ] 0.46 sec. 2025-03-05 13:58:17 03014_analyzer_groupby_fuzz_60317: [ OK ] 0.47 sec. 2025-03-05 13:58:17 03008_groupSortedArray_field: [ OK ] 0.39 sec. 2025-03-05 13:58:17 03023_group_by_use_nulls_analyzer_crashes: [ OK ] 1.46 sec. 2025-03-05 13:58:17 03003_compatibility_setting_bad_value: [ OK ] 0.29 sec. 2025-03-05 13:58:17 03006_analyzer_executable_table_function: [ OK ] 0.38 sec. 2025-03-05 13:58:17 03004_json_named_tuples_inference_ambiguous_paths_as_string: [ OK ] 0.42 sec. 2025-03-05 13:58:17 03003_sql_json_nonsense: [ OK ] 0.42 sec. 2025-03-05 13:58:17 03002_modify_query_cte: [ OK ] 0.48 sec. 2025-03-05 13:58:18 03002_analyzer_prewhere: [ OK ] 0.64 sec. 2025-03-05 13:58:18 03001_insert_threads_deduplication: [ OK ] 0.80 sec. 2025-03-05 13:58:18 03000_virtual_columns_in_prewhere: [ OK ] 0.55 sec. 2025-03-05 13:58:18 02999_scalar_subqueries_bug_1: [ OK ] 0.55 sec. 2025-03-05 13:58:18 02999_scalar_subqueries_bug_2: [ OK ] 0.39 sec. 2025-03-05 13:58:18 02998_primary_key_skip_columns: [ SKIPPED ] 0.00 sec. - not running for current build 2025-03-05 13:58:18 02998_system_dns_cache_table: [ OK ] 0.39 sec. 2025-03-05 13:58:18 02998_attach_partition_not_allowed_if_structure_differs_due_to_materialized_column: [ OK ] 0.50 sec. 2025-03-05 13:58:18 02998_ipv6_hashing: [ OK ] 0.44 sec. 2025-03-05 13:58:19 03009_format_show_database: [ OK ] 2.28 sec. 2025-03-05 13:58:19 03001_bad_error_message_higher_order_functions: [ OK ] 1.61 sec. 2025-03-05 13:58:19 02996_index_compaction_counterexample: [ OK ] 0.48 sec. 2025-03-05 13:58:19 02993_values_escape_quote: [ OK ] 0.52 sec. 2025-03-05 13:58:19 02990_parts_splitter_invalid_ranges: [ OK ] 0.49 sec. 2025-03-05 13:58:19 03008_optimize_equal_ranges: [ OK ] 2.61 sec. 2025-03-05 13:58:19 02990_optimize_uniq_to_count_alias: [ OK ] 0.54 sec. 2025-03-05 13:58:20 02990_arrayFold_nullable_lc: [ OK ] 0.79 sec. 2025-03-05 13:58:20 02981_translate_fixedstring: [ OK ] 0.42 sec. 2025-03-05 13:58:20 02985_dialects_with_distributed_tables: [ OK ] 0.76 sec. 2025-03-05 13:58:21 02973_analyzer_join_use_nulls_column_not_found: [ OK ] 1.29 sec. 2025-03-05 13:58:21 02973_dictionary_table_exception_fix: [ OK ] 1.36 sec. 2025-03-05 13:58:21 02997_fix_datetime64_scale_conversion: [ OK ] 3.24 sec. 2025-03-05 13:58:21 02985_parser_check_stack_size: [ OK ] 2.53 sec. 2025-03-05 13:58:22 02983_empty_map: [ OK ] 2.31 sec. 2025-03-05 13:58:22 02969_analyzer_eliminate_injective_functions: [ OK ] 0.48 sec. 2025-03-05 13:58:22 02969_functions_to_subcolumns_if_null: [ OK ] 0.49 sec. 2025-03-05 13:58:22 02995_forget_partition: [ OK ] 3.64 sec. 2025-03-05 13:58:22 02967_analyzer_fuzz: [ OK ] 0.55 sec. 2025-03-05 13:58:22 02963_invalid_identifier: [ OK ] 0.41 sec. 2025-03-05 13:58:23 02956_fix_to_start_of_milli_microsecond: [ OK ] 0.44 sec. 2025-03-05 13:58:23 02968_mysql_prefer_column_name_to_alias: [ OK ] 1.21 sec. 2025-03-05 13:58:23 02969_archive_seek: [ OK ] 1.61 sec. 2025-03-05 13:58:23 02980_s3_plain_DROP_TABLE_MergeTree: [ OK ] 3.47 sec. 2025-03-05 13:58:23 02952_archive_parsing: [ OK ] 0.41 sec. 2025-03-05 13:58:24 02952_binary: [ OK ] 1.18 sec. 2025-03-05 13:58:24 02949_parallel_replicas_in_subquery: [ OK ] 1.03 sec. 2025-03-05 13:58:24 02956_clickhouse_local_system_parts: [ OK ] 1.79 sec. 2025-03-05 13:58:24 02945_blake3_msan: [ OK ] 0.38 sec. 2025-03-05 13:58:25 03199_unbin_buffer_overflow: [ OK ] 10.78 sec. 2025-03-05 13:58:25 02946_format_values: [ OK ] 1.81 sec. 2025-03-05 13:58:25 02950_part_log_bytes_uncompressed: [ OK ] 2.22 sec. 2025-03-05 13:58:25 02943_create_query_interpreter_sample_block_fix: [ OK ] 0.82 sec. 2025-03-05 13:58:25 02943_order_by_all: [ OK ] 1.15 sec. 2025-03-05 13:58:26 02943_tokenbf_and_ngrambf_indexes_support_match_function: [ OK ] 0.85 sec. 2025-03-05 13:58:26 02935_ipv6_bit_operations: [ OK ] 0.42 sec. 2025-03-05 13:58:26 02935_date_trunc_case_unsensitiveness: [ OK ] 0.52 sec. 2025-03-05 13:58:26 02931_ubsan_error_arena_aligned_alloc: [ OK ] 0.40 sec. 2025-03-05 13:58:27 02922_respect_nulls_parser: [ OK ] 1.01 sec. 2025-03-05 13:58:27 02931_size_virtual_column_use_structure_from_insertion_table: [ OK ] 1.51 sec. 2025-03-05 13:58:27 02931_file_cluster: [ OK ] 1.76 sec. 2025-03-05 13:58:28 02920_unary_operators_functions: [ OK ] 0.41 sec. 2025-03-05 13:58:28 02968_file_log_multiple_read: [ OK ] 6.33 sec. 2025-03-05 13:58:28 02940_variant_text_deserialization: [ OK ] 2.91 sec. 2025-03-05 13:58:28 02920_alter_column_of_projections: [ OK ] 0.96 sec. 2025-03-05 13:58:29 02918_join_pm_lc_crash: [ OK ] 0.66 sec. 2025-03-05 13:58:29 02918_parallel_replicas_custom_key_unavailable_replica: [ OK ] 1.15 sec. 2025-03-05 13:58:29 02911_join_on_nullsafe_optimization: [ OK ] 0.88 sec. 2025-03-05 13:58:30 02920_capnp_protobuf_auto_schema_nested: [ OK ] 2.41 sec. 2025-03-05 13:58:30 02915_input_table_function_in_subquery: [ OK ] 1.92 sec. 2025-03-05 13:58:30 02918_sqlite_path_check: [ OK ] 2.10 sec. 2025-03-05 13:58:31 02906_flatten_only_true_nested: [ OK ] 0.41 sec. 2025-03-05 13:58:31 02932_kill_query_sleep: [ OK ] 5.20 sec. 2025-03-05 13:58:31 02910_replicated_merge_parameters_must_consistent: [ OK ] 1.27 sec. 2025-03-05 13:58:32 02905_show_setting_query: [ OK ] 0.47 sec. 2025-03-05 13:58:32 02911_analyzer_order_by_read_in_order_query_plan: [ OK ] 3.36 sec. 2025-03-05 13:58:32 02907_read_buffer_content_is_cached_multiple_blobs: [ OK ] 2.31 sec. 2025-03-05 13:58:33 02902_select_subcolumns_from_engine_null: [ OK ] 0.46 sec. 2025-03-05 13:58:33 02905_system_logs_hostname: [ OK ] 2.39 sec. 2025-03-05 13:58:33 02907_http_exception_json_bug: [ OK ] 3.36 sec. 2025-03-05 13:58:33 02896_optimize_array_exists_to_has_with_date: [ OK ] 0.40 sec. 2025-03-05 13:58:34 02893_trash_optimization: [ OK ] 0.40 sec. 2025-03-05 13:58:34 02900_date_time_check_overflow: [ OK ] 1.41 sec. 2025-03-05 13:58:34 02903_client_insert_in_background: [ OK ] 2.33 sec. 2025-03-05 13:58:34 02892_rocksdb_trivial_count: [ OK ] 0.66 sec. 2025-03-05 13:58:34 02892_SummingMergeTree_Nested: [ OK ] 0.58 sec. 2025-03-05 13:58:34 02891_alter_update_adaptive_granularity: [ OK ] 0.58 sec. 2025-03-05 13:58:35 02890_partition_prune_in_extra_columns: [ OK ] 0.45 sec. 2025-03-05 13:58:35 02891_rename_table_without_keyword: [ OK ] 0.75 sec. 2025-03-05 13:58:35 02905_csv_unquoted_string_with_cr: [ OK ] 4.10 sec. 2025-03-05 13:58:35 02888_single_state_nullable_type: [ OK ] 0.46 sec. 2025-03-05 13:58:35 02888_obsolete_settings: [ OK ] 0.56 sec. 2025-03-05 13:58:35 02884_parallel_window_functions: [ SKIPPED ] 0.00 sec. - not running for current build 2025-03-05 13:58:35 02890_untuple_column_names: [ OK ] 0.89 sec. 2025-03-05 13:58:35 02885_create_distributed_table_without_as: [ OK ] 0.54 sec. 2025-03-05 13:58:35 02898_input_format_values_allow_data_after_semicolon: [ OK ] 2.43 sec. 2025-03-05 13:58:36 02884_duplicate_index_name: [ OK ] 0.40 sec. 2025-03-05 13:58:36 02881_system_detached_parts_modification_time: [ OK ] 0.65 sec. 2025-03-05 13:58:36 02874_infer_objects_as_named_tuples: [ OK ] 0.73 sec. 2025-03-05 13:58:36 02875_fix_column_decimal_serialization: [ OK ] 0.81 sec. 2025-03-05 13:58:36 02871_multiple_joins_rewriter_v2_handle_last_table_columns: [ OK ] 0.50 sec. 2025-03-05 13:58:36 02869_unicode_minus: [ OK ] 0.39 sec. 2025-03-05 13:58:37 02878_use_structure_from_insertion_table_with_explicit_insert_columns: [ OK ] 1.83 sec. 2025-03-05 13:58:38 02863_non_const_timezone_check: [ OK ] 1.13 sec. 2025-03-05 13:58:38 02842_move_pk_to_end_of_prewhere: [ OK ] 1.40 sec. 2025-03-05 13:58:38 02869_parallel_replicas_read_from_several: [ OK ] 1.91 sec. 2025-03-05 13:58:39 02840_grace_hash_join_structure_mismatch: [ OK ] 0.97 sec. 2025-03-05 13:58:39 02842_table_function_file_filter_by_virtual_columns: [ OK ] 1.90 sec. 2025-03-05 13:58:40 02889_file_log_save_errors: [ OK ] 5.52 sec. 2025-03-05 13:58:41 02836_file_diagnostics_while_reading_header: [ OK ] 2.00 sec. 2025-03-05 13:58:42 02834_add_sub_date_functions: [ OK ] 1.82 sec. 2025-03-05 13:58:42 02841_not_ready_set_bug: [ OK ] 3.96 sec. 2025-03-05 13:58:43 02832_transform_fixed_string_no_default: [ OK ] 0.67 sec. 2025-03-05 13:58:43 02833_tuple_concat: [ OK ] 1.25 sec. 2025-03-05 13:58:43 02832_integer_type_inference: [ OK ] 0.76 sec. 2025-03-05 13:58:43 02831_trash: [ OK ] 0.45 sec. 2025-03-05 13:58:43 02818_parameterized_view_with_cte_multiple_usage: [ OK ] 0.63 sec. 2025-03-05 13:58:44 02842_mutations_replace_non_deterministic: [ OK ] 6.99 sec. 2025-03-05 13:58:44 02815_logical_error_cannot_get_column_name_of_set: [ OK ] 0.71 sec. 2025-03-05 13:58:45 02814_order_by_tuple_window_function: [ OK ] 0.42 sec. 2025-03-05 13:58:45 02872_null_as_default_nested: [ OK ] 9.22 sec. 2025-03-05 13:58:45 02814_create_index_uniq_noop: [ OK ] 0.33 sec. 2025-03-05 13:58:45 02813_any_value: [ OK ] 0.45 sec. 2025-03-05 13:58:46 02813_array_concat_agg: [ OK ] 0.82 sec. 2025-03-05 13:58:46 02831_regexp_analyze_recursion: [ OK ] 3.21 sec. 2025-03-05 13:58:46 02812_csv_date_time_with_comma: [ OK ] 0.45 sec. 2025-03-05 13:58:47 02810_fix_remove_dedundant_distinct_view: [ OK ] 0.88 sec. 2025-03-05 13:58:47 02810_convert_uuid_to_uint128: [ OK ] 0.79 sec. 2025-03-05 13:58:48 02810_system_jemalloc_bins: [ OK ] 0.70 sec. 2025-03-05 13:58:48 02812_large_varints: [ OK ] 2.37 sec. 2025-03-05 13:58:48 02814_currentDatabase_for_table_functions: [ OK ] 3.62 sec. 2025-03-05 13:58:48 02808_aliases_inside_case: [ OK ] 0.41 sec. 2025-03-05 13:58:49 02802_with_cube_with_totals: [ OK ] 0.53 sec. 2025-03-05 13:58:49 02809_has_subsequence: [ OK ] 1.42 sec. 2025-03-05 13:58:49 02801_transform_nullable: [ OK ] 0.78 sec. 2025-03-05 13:58:49 02795_full_join_assert_cast: [ OK ] 0.42 sec. 2025-03-05 13:58:50 02791_predicate_pushdown_different_types: [ OK ] 0.38 sec. 2025-03-05 13:58:50 02800_clickhouse_local_default_settings: [ OK ] 1.41 sec. 2025-03-05 13:58:50 02790_fix_coredump_when_compile_expression: [ OK ] 0.43 sec. 2025-03-05 13:58:50 02789_jit_cannot_convert_column: [ OK ] 0.46 sec. 2025-03-05 13:58:51 02798_substring_index: [ OK ] 2.12 sec. 2025-03-05 13:58:51 02789_functions_after_sorting_and_columns_with_same_names_bug_2: [ OK ] 0.82 sec. 2025-03-05 13:58:51 02785_global_join_too_many_columns: [ OK ] 0.70 sec. 2025-03-05 13:58:52 02784_move_all_conditions_to_prewhere_analyzer_asan: [ OK ] 0.59 sec. 2025-03-05 13:58:52 02783_parsedatetimebesteffort_syslog: [ FAIL ] 0.50 sec. - result differs with reference: 2025-03-05 13:58:52 --- /usr/share/clickhouse-test/queries/0_stateless/02783_parsedatetimebesteffort_syslog.reference 2025-03-05 13:54:13.837007580 -0600 2025-03-05 13:58:52 +++ /tmp/clickhouse-test/0_stateless/02783_parsedatetimebesteffort_syslog.stdout 2025-03-05 13:58:52.188112846 -0600 2025-03-05 13:58:52 @@ -23,15 +23,15 @@ 2025-03-05 13:58:52 Row 1: 2025-03-05 13:58:52 ────── 2025-03-05 13:58:52 syslog_arg: Jul 1 23:59:30 2025-03-05 13:58:52 -res: 2022-06-30 23:59:30 2025-03-05 13:58:52 -res_null: 2022-06-30 23:59:30 2025-03-05 13:58:52 -res_zero: 2022-06-30 23:59:30 2025-03-05 13:58:52 -res_us: 2022-06-30 23:59:30 2025-03-05 13:58:52 -res_us_null: 2022-06-30 23:59:30 2025-03-05 13:58:52 -res_us_zero: 2022-06-30 23:59:30 2025-03-05 13:58:52 -res64: 2022-06-30 23:59:30.000 2025-03-05 13:58:52 -res64_null: 2022-06-30 23:59:30.000 2025-03-05 13:58:52 -res64_zero: 2022-06-30 23:59:30.000 2025-03-05 13:58:52 -res64_us: 2022-06-30 23:59:30.000 2025-03-05 13:58:52 -res64_us_null: 2022-06-30 23:59:30.000 2025-03-05 13:58:52 -res64_us_zero: 2022-06-30 23:59:30.000 2025-03-05 13:58:52 +res: 2022-07-01 23:59:30 2025-03-05 13:58:52 +res_null: 2022-07-01 23:59:30 2025-03-05 13:58:52 +res_zero: 2022-07-01 23:59:30 2025-03-05 13:58:52 +res_us: 2022-07-01 23:59:30 2025-03-05 13:58:52 +res_us_null: 2022-07-01 23:59:30 2025-03-05 13:58:52 +res_us_zero: 2022-07-01 23:59:30 2025-03-05 13:58:52 +res64: 2022-07-01 23:59:30.000 2025-03-05 13:58:52 +res64_null: 2022-07-01 23:59:30.000 2025-03-05 13:58:52 +res64_zero: 2022-07-01 23:59:30.000 2025-03-05 13:58:52 +res64_us: 2022-07-01 23:59:30.000 2025-03-05 13:58:52 +res64_us_null: 2022-07-01 23:59:30.000 2025-03-05 13:58:52 +res64_us_zero: 2022-07-01 23:59:30.000 2025-03-05 13:58:52 2025-03-05 13:58:52 2025-03-05 13:58:52 Settings used in the test: --max_insert_threads 0 --group_by_two_level_threshold 778747 --group_by_two_level_threshold_bytes 12381508 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 1 --min_chunk_bytes_for_parallel_parsing 11309255 --max_read_buffer_size 675650 --prefer_localhost_replica 1 --max_block_size 47131 --max_threads 14 --optimize_append_index 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 5 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 124950 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 1 --min_bytes_to_use_mmap_io 6548963958 --local_filesystem_read_method io_uring --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 50 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 64Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 0 --compile_sort_description 1 --merge_tree_coarse_index_granularity 12 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 4887117351 --max_bytes_before_remerge_sort 2088417876 --min_compress_block_size 1185463 --max_compress_block_size 243344 --merge_tree_compact_parts_min_granules_to_multibuffer_read 50 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 9167465 --http_wait_end_of_query True --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 0 --session_timezone America/Hermosillo --prefer_warmed_unmerged_parts_seconds 3 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction False --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.83 2025-03-05 13:58:52 2025-03-05 13:58:52 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 9276514430 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 3407646246 --index_granularity_bytes 25657313 --merge_max_block_size 2971 --index_granularity 18138 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 35816 --primary_key_compress_block_size 12035 --replace_long_file_name_to_hash 1 --max_file_name_length 128 --min_bytes_for_full_part_storage 365513879 --compact_parts_max_bytes_to_buffer 359546178 --compact_parts_max_granules_to_buffer 154 --compact_parts_merge_max_bytes_to_prefetch_part 28237008 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 100 --old_parts_lifetime 30 2025-03-05 13:58:52 2025-03-05 13:58:52 Database: test_w22ii4wr 2025-03-05 13:58:52 02783_max_bytes_to_read_in_schema_inference: [ OK ] 0.48 sec. 2025-03-05 13:58:53 02771_jit_functions_comparison_crash: [ OK ] 0.55 sec. 2025-03-05 13:58:55 02806_system_parts_columns_modification_time: [ OK ] 6.83 sec. 2025-03-05 13:58:56 02781_data_skipping_index_merge_tree_min_for_seek: [ OK ] 3.83 sec. 2025-03-05 13:58:56 02752_is_null_priority: [ OK ] 0.39 sec. 2025-03-05 13:58:56 02767_into_outfile_extensions_msan: [ OK ] 1.52 sec. 2025-03-05 13:58:56 02815_join_algorithm_setting: [ OK ] 12.81 sec. 2025-03-05 13:58:56 02834_remote_session_log: [ OK ] 16.75 sec. 2025-03-05 13:58:57 02771_system_user_processes: [ OK ] 3.95 sec. 2025-03-05 13:58:57 02735_array_map_array_of_tuples: [ OK ] 0.48 sec. 2025-03-05 13:59:00 02737_session_timezone: [ OK ] 3.99 sec. 2025-03-05 13:59:01 02717_pretty_json: [ OK ] 0.50 sec. 2025-03-05 13:59:01 02722_matcher_join_use_nulls: [ OK ] 4.12 sec. 2025-03-05 13:59:01 02752_forbidden_headers: [ OK ] 4.97 sec. 2025-03-05 13:59:01 02740_hashed_dictionary_load_factor_smoke: [ OK ] 5.01 sec. 2025-03-05 13:59:01 02715_or_null: [ OK ] 0.52 sec. 2025-03-05 13:59:01 02718_cli_dashed_options_parsing: [ OK ] 4.54 sec. 2025-03-05 13:59:02 02710_date_diff_aliases: [ OK ] 0.56 sec. 2025-03-05 13:59:02 02710_topk_with_empty_array: [ OK ] 0.43 sec. 2025-03-05 13:59:02 02711_trim_aliases: [ OK ] 0.76 sec. 2025-03-05 13:59:02 02704_storage_merge_explain_graph_crash: [ OK ] 0.73 sec. 2025-03-05 13:59:03 02707_keeper_map_delete_update_strict: [ OK ] 1.30 sec. 2025-03-05 13:59:03 02706_kolmogorov_smirnov_test: [ OK ] 1.13 sec. 2025-03-05 13:59:03 02700_regexp_operator: [ OK ] 0.40 sec. 2025-03-05 13:59:03 02708_dotProduct: [ OK ] 1.81 sec. 2025-03-05 13:59:03 02699_polygons_sym_difference_total_analyzer: [ OK ] 0.42 sec. 2025-03-05 13:59:04 02698_marked_dropped_tables: [ OK ] 0.49 sec. 2025-03-05 13:59:04 02693_multiple_joins_in: [ OK ] 0.46 sec. 2025-03-05 13:59:04 02694_wrong_identifier_shouldnt_be_accepted: [ OK ] 0.67 sec. 2025-03-05 13:59:04 02692_multiple_joins_unicode: [ OK ] 0.65 sec. 2025-03-05 13:59:04 02689_meaningless_data_types: [ OK ] 0.53 sec. 2025-03-05 13:59:04 02691_multiple_joins_backtick_identifiers: [ OK ] 0.71 sec. 2025-03-05 13:59:05 02688_long_aggregate_function_names: [ OK ] 0.44 sec. 2025-03-05 13:59:05 02677_get_subcolumn_array_of_tuples: [ OK ] 0.52 sec. 2025-03-05 13:59:05 02675_is_ipv6_function_fix: [ OK ] 0.39 sec. 2025-03-05 13:59:06 02674_null_default_structure: [ OK ] 0.45 sec. 2025-03-05 13:59:06 02668_column_block_number_vertical_merge: [ OK ] 0.95 sec. 2025-03-05 13:59:06 02681_aggregation_by_partitions_bug: [ OK ] 1.98 sec. 2025-03-05 13:59:09 02597_column_update_and_replication: [ OK ] 2.05 sec. 2025-03-05 13:59:10 02704_keeper_map_zk_nodes: [ OK ] 8.36 sec. 2025-03-05 13:59:13 02581_width_bucket: [ OK ] 2.69 sec. 2025-03-05 13:59:13 02577_analyzer_array_join_calc_twice: [ OK ] 0.60 sec. 2025-03-05 13:59:14 02784_connection_string: [ OK ] 22.90 sec. 2025-03-05 13:59:14 02575_merge_prewhere_ephemeral: [ OK ] 0.70 sec. 2025-03-05 13:59:14 02575_merge_prewhere_default_expression: [ OK ] 0.62 sec. 2025-03-05 13:59:15 02704_max_backup_bandwidth: [ OK ] 12.36 sec. 2025-03-05 13:59:15 02573_insert_null_as_default_null_as_empty_nested: [ OK ] 1.17 sec. 2025-03-05 13:59:16 02568_json_array_length: [ OK ] 0.75 sec. 2025-03-05 13:59:17 02572_materialized_views_ignore_errors: [ OK ] 2.25 sec. 2025-03-05 13:59:17 02568_and_consistency: [ OK ] 1.12 sec. 2025-03-05 13:59:18 02566_analyzer_limit_settings_distributed: [ OK ] 1.17 sec. 2025-03-05 13:59:21 02943_variant_type_with_different_local_and_global_order: [ OK ] 56.40 sec. 2025-03-05 13:59:21 02563_arrow_low_cardinality_bug: [ OK ] 3.25 sec. 2025-03-05 13:59:22 02561_with_fill_date_datetime_incompatible: [ OK ] 0.78 sec. 2025-03-05 13:59:23 02661_read_from_archive_tarxz: [ OK ] 17.04 sec. 2025-03-05 13:59:23 02560_count_digits: [ OK ] 1.07 sec. 2025-03-05 13:59:23 02661_read_from_archive_7z: [ OK ] 16.53 sec. 2025-03-05 13:59:24 02553_type_object_analyzer: [ OK ] 0.69 sec. 2025-03-05 13:59:24 02556_local_with_totals_and_extremes: [ OK ] 1.47 sec. 2025-03-05 13:59:24 02552_regression_crash: [ OK ] 0.61 sec. 2025-03-05 13:59:25 02552_client_format_settings: [ OK ] 0.44 sec. 2025-03-05 13:59:25 02561_temporary_table_grants: [ OK ] 6.89 sec. 2025-03-05 13:59:25 02542_table_function_format: [ OK ] 0.73 sec. 2025-03-05 13:59:25 02560_regexp_denial_of_service: [ OK ] 4.72 sec. 2025-03-05 13:59:26 02534_s3_heap_use_after_free: [ OK ] 0.82 sec. 2025-03-05 13:59:26 02534_join_prewhere_bug: [ OK ] 1.36 sec. 2025-03-05 13:59:26 02532_analyzer_aggregation_with_rollup: [ OK ] 0.92 sec. 2025-03-05 13:59:26 02558_system_processes_elapsed: [ OK ] 3.79 sec. 2025-03-05 13:59:27 02572_query_views_log_background_thread: [ OK ] 11.74 sec. 2025-03-05 13:59:27 02530_ip_part_id: [ OK ] 0.94 sec. 2025-03-05 13:59:27 02590_interserver_mode_client_info_initial_query_start_time: [ OK ] 18.25 sec. 2025-03-05 13:59:27 02521_analyzer_aggregation_without_column: [ OK ] 0.57 sec. 2025-03-05 13:59:27 02517_uuid_parsing: [ OK ] 0.48 sec. 2025-03-05 13:59:28 02525_different_engines_in_temporary_tables: [ OK ] 1.37 sec. 2025-03-05 13:59:28 02515_projections_with_totals: [ OK ] 0.55 sec. 2025-03-05 13:59:28 02516_projections_and_context: [ OK ] 0.94 sec. 2025-03-05 13:59:28 02523_array_shuffle: [ OK ] 2.01 sec. 2025-03-05 13:59:29 02514_bad_index_granularity: [ OK ] 0.46 sec. 2025-03-05 13:59:29 02521_grouping_sets_plus_memory_efficient_aggr: [ OK ] 1.94 sec. 2025-03-05 13:59:29 02512_array_join_name_resolution: [ OK ] 0.51 sec. 2025-03-05 13:59:29 02518_parquet_arrow_orc_boolean_value: [ OK ] 2.28 sec. 2025-03-05 13:59:29 02504_parse_datetime_best_effort_calebeaires: [ OK ] 0.47 sec. 2025-03-05 13:59:29 02508_index_analysis_to_date_timezone: [ OK ] 0.67 sec. 2025-03-05 13:59:29 02513_prewhere_combine_step_filters: [ OK ] 0.95 sec. 2025-03-05 13:59:29 02503_mysql_compat_utc_timestamp: [ OK ] 0.38 sec. 2025-03-05 13:59:30 02503_bad_compatibility_setting: [ OK ] 0.51 sec. 2025-03-05 13:59:30 02501_analyzer_expired_context_crash_fix: [ OK ] 0.60 sec. 2025-03-05 13:59:30 02500_analyzer_storage_view_crash_fix: [ OK ] 0.52 sec. 2025-03-05 13:59:30 02539_vertical_merge_compact_parts: [ OK ] 5.28 sec. 2025-03-05 13:59:30 02498_analyzer_settings_push_down: [ OK ] 0.57 sec. 2025-03-05 13:59:30 02499_quantile_nan_ubsan_msan: [ OK ] 0.87 sec. 2025-03-05 13:59:31 02494_array_function_range: [ OK ] 0.62 sec. 2025-03-05 13:59:31 02497_source_part_is_intact_when_mutation: [ OK ] 1.02 sec. 2025-03-05 13:59:31 02487_create_index_normalize_functions: [ OK ] 0.64 sec. 2025-03-05 13:59:31 02482_execute_functions_before_sorting_bug: [ OK ] 0.51 sec. 2025-03-05 13:59:31 02481_xxh3_hash_function: [ OK ] 0.35 sec. 2025-03-05 13:59:32 02481_analyzer_optimize_grouping_sets_keys: [ OK ] 0.52 sec. 2025-03-05 13:59:32 02481_parquet_list_monotonically_increasing_offsets: [ SKIPPED ] 0.00 sec. - not running for current build 2025-03-05 13:59:32 02495_concat_with_separator: [ OK ] 1.78 sec. 2025-03-05 13:59:32 02482_value_block_parsing: [ OK ] 1.63 sec. 2025-03-05 13:59:32 02517_infer_uint64_in_case_of_int64_overflow: [ OK ] 4.91 sec. 2025-03-05 13:59:32 02481_merge_array_join_sample_by: [ OK ] 1.24 sec. 2025-03-05 13:59:32 02477_is_null_parser: [ OK ] 0.39 sec. 2025-03-05 13:59:33 02478_projection_and_alter_low_cardinality: [ OK ] 0.60 sec. 2025-03-05 13:59:33 02473_map_element_nullable: [ OK ] 0.77 sec. 2025-03-05 13:59:33 02467_cross_join_three_table_functions: [ OK ] 0.59 sec. 2025-03-05 13:59:34 02463_julian_day_ubsan: [ OK ] 0.53 sec. 2025-03-05 13:59:34 02480_tets_show_full: [ OK ] 2.24 sec. 2025-03-05 13:59:34 02471_wrong_date_monotonicity: [ OK ] 1.60 sec. 2025-03-05 13:59:35 02466_distributed_query_profiler: [ OK ] 2.25 sec. 2025-03-05 13:59:35 02457_parse_date_time_best_effort: [ OK ] 1.30 sec. 2025-03-05 13:59:36 02456_test_zero_copy_mutation: [ OK ] 1.85 sec. 2025-03-05 13:59:36 02456_BLAKE3_hash_function_test: [ OK ] 0.43 sec. 2025-03-05 13:59:37 02456_summing_mt_lc: [ OK ] 1.47 sec. 2025-03-05 13:59:37 02481_parquet_int_list_multiple_chunks: [ OK ] 5.27 sec. 2025-03-05 13:59:37 02456_alter-nullable-column-bag-2: [ OK ] 1.69 sec. 2025-03-05 13:59:38 02454_compressed_marks_in_compact_part: [ OK ] 1.34 sec. 2025-03-05 13:59:39 02455_count_state_asterisk: [ OK ] 2.05 sec. 2025-03-05 13:59:39 02454_create_table_with_custom_disk: [ OK ] 2.18 sec. 2025-03-05 13:59:39 02452_check_low_cardinality: [ OK ] 2.19 sec. 2025-03-05 13:59:40 02428_batch_nullable_assert: [ OK ] 0.55 sec. 2025-03-05 13:59:40 02451_variadic_null_garbage_data: [ OK ] 1.70 sec. 2025-03-05 13:59:40 02436_system_zookeeper_context: [ OK ] 1.15 sec. 2025-03-05 13:59:41 02462_distributions: [ OK ] 7.43 sec. 2025-03-05 13:59:41 02428_partial_sort_optimization_bug: [ OK ] 1.04 sec. 2025-03-05 13:59:42 02428_decimal_in_floating_point_literal: [ OK ] 1.44 sec. 2025-03-05 13:59:42 02426_pod_array_overflow_3: [ OK ] 0.92 sec. 2025-03-05 13:59:42 02426_create_suspicious_fixed_string: [ OK ] 0.85 sec. 2025-03-05 13:59:42 02426_to_string_nullable_fixedstring: [ OK ] 0.43 sec. 2025-03-05 13:59:44 02428_delete_with_settings: [ OK ] 3.43 sec. 2025-03-05 13:59:44 02426_orc_bug: [ OK ] 1.50 sec. 2025-03-05 13:59:44 02420_stracktrace_debug_symbols: [ OK ] 1.97 sec. 2025-03-05 13:59:45 02418_keeper_map_keys_limit: [ OK ] 1.14 sec. 2025-03-05 13:59:45 02409_url_format_detection: [ OK ] 0.36 sec. 2025-03-05 13:59:45 02416_rocksdb_delete_update: [ OK ] 1.08 sec. 2025-03-05 13:59:45 02407_array_element_from_map_wrong_type: [ OK ] 0.49 sec. 2025-03-05 13:59:46 02403_ttl_column_multiple_times: [ OK ] 0.67 sec. 2025-03-05 13:59:46 02403_big_http_chunk_size: [ OK ] 1.22 sec. 2025-03-05 13:59:47 02423_insert_summary_behaviour: [ OK ] 4.19 sec. 2025-03-05 13:59:47 02393_every_metric_must_have_documentation: [ OK ] 0.44 sec. 2025-03-05 13:59:47 02403_enable_extended_results_for_datetime_functions: [ OK ] 1.86 sec. 2025-03-05 13:59:47 02399_merge_tree_mutate_in_partition: [ OK ] 0.93 sec. 2025-03-05 13:59:47 02387_parse_date_as_datetime: [ OK ] 0.49 sec. 2025-03-05 13:59:47 02386_set_columns_order: [ OK ] 0.58 sec. 2025-03-05 13:59:47 02388_conversion_from_string_with_datetime64_to_date_and_date32: [ OK ] 0.92 sec. 2025-03-05 13:59:48 02381_parse_array_of_tuples: [ OK ] 0.45 sec. 2025-03-05 13:59:48 02383_analyzer_merge_tree_self_join: [ OK ] 0.91 sec. 2025-03-05 13:59:49 02382_analyzer_matcher_join_using: [ OK ] 1.61 sec. 2025-03-05 13:59:49 02381_arrow_dict_to_lc: [ OK ] 1.43 sec. 2025-03-05 13:59:49 02496_remove_redundant_sorting: [ OK ] 19.26 sec. 2025-03-05 13:59:49 02377_fix_file_virtual_column: [ OK ] 0.44 sec. 2025-03-05 13:59:50 02375_pretty_formats: [ OK ] 0.64 sec. 2025-03-05 13:59:53 02375_stack_trace_no_addresses: [ OK ] 2.86 sec. 2025-03-05 13:59:53 02380_insert_mv_race: [ OK ] 5.51 sec. 2025-03-05 13:59:54 02374_in_tuple_index: [ OK ] 0.65 sec. 2025-03-05 13:59:55 02373_progress_contain_result: [ OK ] 1.21 sec. 2025-03-05 13:59:56 02375_rocksdb_with_filters: [ OK ] 6.65 sec. 2025-03-05 13:59:56 02370_analyzer_in_function: [ OK ] 1.23 sec. 2025-03-05 13:59:56 02377_majority_insert_quorum_zookeeper_long: [ OK ] 8.46 sec. 2025-03-05 13:59:57 02437_drop_mv_restart_replicas: [ OK ] 18.56 sec. 2025-03-05 13:59:57 02364_dictionary_datetime_64_attribute_crash: [ OK ] 0.79 sec. 2025-03-05 13:59:58 02357_file_default_value: [ OK ] 0.63 sec. 2025-03-05 13:59:59 02360_send_logs_level_colors: [ OK ] 2.25 sec. 2025-03-05 14:00:01 02354_vector_search_default_granularity: [ OK ] 1.43 sec. 2025-03-05 14:00:02 02354_vector_search_queries: [ FAIL ] 4.15 sec. - result differs with reference: 2025-03-05 14:00:02 --- /usr/share/clickhouse-test/queries/0_stateless/02354_vector_search_queries.reference 2025-03-05 13:54:13.777007607 -0600 2025-03-05 14:00:02 +++ /tmp/clickhouse-test/0_stateless/02354_vector_search_queries.stdout 2025-03-05 14:00:02.587955816 -0600 2025-03-05 14:00:02 @@ -16,7 +16,7 @@ 2025-03-05 14:00:02 6 [0,2.1] 0.09999990463256836 2025-03-05 14:00:02 7 [0,2.2] 0.20000004768371582 2025-03-05 14:00:02 - Annoy: WHERE-type, EXPLAIN 2025-03-05 14:00:02 -Expression ((Projection + Before ORDER BY)) 2025-03-05 14:00:02 +Expression ((Project names + Projection)) 2025-03-05 14:00:02 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 14:00:02 Expression 2025-03-05 14:00:02 ReadFromMergeTree (default.tab_annoy) 2025-03-05 14:00:02 @@ -25,29 +25,19 @@ 2025-03-05 14:00:02 Condition: true 2025-03-05 14:00:02 Parts: 1/1 2025-03-05 14:00:02 Granules: 1/1 2025-03-05 14:00:02 - Skip 2025-03-05 14:00:02 - Name: idx 2025-03-05 14:00:02 - Description: annoy GRANULARITY 100000000 2025-03-05 14:00:02 - Parts: 1/1 2025-03-05 14:00:02 - Granules: 1/1 2025-03-05 14:00:02 - Annoy: ORDER-BY-type, EXPLAIN 2025-03-05 14:00:02 -Expression (Projection) 2025-03-05 14:00:02 +Expression (Project names) 2025-03-05 14:00:02 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 14:00:02 Sorting (Sorting for ORDER BY) 2025-03-05 14:00:02 - Expression (Before ORDER BY) 2025-03-05 14:00:02 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2025-03-05 14:00:02 ReadFromMergeTree (default.tab_annoy) 2025-03-05 14:00:02 Indexes: 2025-03-05 14:00:02 PrimaryKey 2025-03-05 14:00:02 Condition: true 2025-03-05 14:00:02 Parts: 1/1 2025-03-05 14:00:02 Granules: 1/1 2025-03-05 14:00:02 - Skip 2025-03-05 14:00:02 - Name: idx 2025-03-05 14:00:02 - Description: annoy GRANULARITY 100000000 2025-03-05 14:00:02 - Parts: 1/1 2025-03-05 14:00:02 - Granules: 1/1 2025-03-05 14:00:02 - Usearch: WHERE-type, EXPLAIN 2025-03-05 14:00:02 -Expression ((Projection + Before ORDER BY)) 2025-03-05 14:00:02 +Expression ((Project names + Projection)) 2025-03-05 14:00:02 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 14:00:02 Expression 2025-03-05 14:00:02 ReadFromMergeTree (default.tab_usearch) 2025-03-05 14:00:02 @@ -56,27 +46,17 @@ 2025-03-05 14:00:02 Condition: true 2025-03-05 14:00:02 Parts: 1/1 2025-03-05 14:00:02 Granules: 1/1 2025-03-05 14:00:02 - Skip 2025-03-05 14:00:02 - Name: idx 2025-03-05 14:00:02 - Description: usearch GRANULARITY 100000000 2025-03-05 14:00:02 - Parts: 1/1 2025-03-05 14:00:02 - Granules: 1/1 2025-03-05 14:00:02 - Usearch: ORDER-BY-type, EXPLAIN 2025-03-05 14:00:02 -Expression (Projection) 2025-03-05 14:00:02 +Expression (Project names) 2025-03-05 14:00:02 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 14:00:02 Sorting (Sorting for ORDER BY) 2025-03-05 14:00:02 - Expression (Before ORDER BY) 2025-03-05 14:00:02 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2025-03-05 14:00:02 ReadFromMergeTree (default.tab_usearch) 2025-03-05 14:00:02 Indexes: 2025-03-05 14:00:02 PrimaryKey 2025-03-05 14:00:02 Condition: true 2025-03-05 14:00:02 Parts: 1/1 2025-03-05 14:00:02 Granules: 1/1 2025-03-05 14:00:02 - Skip 2025-03-05 14:00:02 - Name: idx 2025-03-05 14:00:02 - Description: usearch GRANULARITY 100000000 2025-03-05 14:00:02 - Parts: 1/1 2025-03-05 14:00:02 - Granules: 1/1 2025-03-05 14:00:02 ARRAY vectors, 12 rows, index_granularity = 3, GRANULARITY = 2 --> 4 granules, 2 indexed block 2025-03-05 14:00:02 - Annoy: WHERE-type 2025-03-05 14:00:02 6 [0,2] 0 2025-03-05 14:00:02 @@ -95,7 +75,7 @@ 2025-03-05 14:00:02 7 [0,2.1] 0.09999990463256836 2025-03-05 14:00:02 8 [0,2.2] 0.20000004768371582 2025-03-05 14:00:02 - Annoy: WHERE-type, EXPLAIN 2025-03-05 14:00:02 -Expression ((Projection + Before ORDER BY)) 2025-03-05 14:00:02 +Expression ((Project names + Projection)) 2025-03-05 14:00:02 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 14:00:02 Expression 2025-03-05 14:00:02 ReadFromMergeTree (default.tab_annoy) 2025-03-05 14:00:02 @@ -104,29 +84,19 @@ 2025-03-05 14:00:02 Condition: true 2025-03-05 14:00:02 Parts: 1/1 2025-03-05 14:00:02 Granules: 4/4 2025-03-05 14:00:02 - Skip 2025-03-05 14:00:02 - Name: idx 2025-03-05 14:00:02 - Description: annoy GRANULARITY 2 2025-03-05 14:00:02 - Parts: 1/1 2025-03-05 14:00:02 - Granules: 1/4 2025-03-05 14:00:02 - Annoy: ORDER-BY-type, EXPLAIN 2025-03-05 14:00:02 -Expression (Projection) 2025-03-05 14:00:02 +Expression (Project names) 2025-03-05 14:00:02 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 14:00:02 Sorting (Sorting for ORDER BY) 2025-03-05 14:00:02 - Expression (Before ORDER BY) 2025-03-05 14:00:02 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2025-03-05 14:00:02 ReadFromMergeTree (default.tab_annoy) 2025-03-05 14:00:02 Indexes: 2025-03-05 14:00:02 PrimaryKey 2025-03-05 14:00:02 Condition: true 2025-03-05 14:00:02 Parts: 1/1 2025-03-05 14:00:02 Granules: 4/4 2025-03-05 14:00:02 - Skip 2025-03-05 14:00:02 - Name: idx 2025-03-05 14:00:02 - Description: annoy GRANULARITY 2 2025-03-05 14:00:02 - Parts: 1/1 2025-03-05 14:00:02 - Granules: 2/4 2025-03-05 14:00:02 - Usearch: WHERE-type, EXPLAIN 2025-03-05 14:00:02 -Expression ((Projection + Before ORDER BY)) 2025-03-05 14:00:02 +Expression ((Project names + Projection)) 2025-03-05 14:00:02 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 14:00:02 Expression 2025-03-05 14:00:02 ReadFromMergeTree (default.tab_usearch) 2025-03-05 14:00:02 @@ -135,27 +105,17 @@ 2025-03-05 14:00:02 Condition: true 2025-03-05 14:00:02 Parts: 1/1 2025-03-05 14:00:02 Granules: 4/4 2025-03-05 14:00:02 - Skip 2025-03-05 14:00:02 - Name: idx 2025-03-05 14:00:02 - Description: usearch GRANULARITY 2 2025-03-05 14:00:02 - Parts: 1/1 2025-03-05 14:00:02 - Granules: 1/4 2025-03-05 14:00:02 - Usearch: ORDER-BY-type, EXPLAIN 2025-03-05 14:00:02 -Expression (Projection) 2025-03-05 14:00:02 +Expression (Project names) 2025-03-05 14:00:02 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 14:00:02 Sorting (Sorting for ORDER BY) 2025-03-05 14:00:02 - Expression (Before ORDER BY) 2025-03-05 14:00:02 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2025-03-05 14:00:02 ReadFromMergeTree (default.tab_usearch) 2025-03-05 14:00:02 Indexes: 2025-03-05 14:00:02 PrimaryKey 2025-03-05 14:00:02 Condition: true 2025-03-05 14:00:02 Parts: 1/1 2025-03-05 14:00:02 Granules: 4/4 2025-03-05 14:00:02 - Skip 2025-03-05 14:00:02 - Name: idx 2025-03-05 14:00:02 - Description: usearch GRANULARITY 2 2025-03-05 14:00:02 - Parts: 1/1 2025-03-05 14:00:02 - Granules: 2/4 2025-03-05 14:00:02 TUPLE vectors and special cases 2025-03-05 14:00:02 - Annoy: WHERE-type 2025-03-05 14:00:02 0 (4.6,2.3) 0.5527864045000421 2025-03-05 14:00:02 @@ -163,24 +123,27 @@ 2025-03-05 14:00:02 2 (4.2,3.4) 0.37080174340866845 2025-03-05 14:00:02 - Annoy: ORDER-BY-type 2025-03-05 14:00:02 6 (1,9.3) 0.005731362878640178 2025-03-05 14:00:02 +4 (2.4,5.2) 0.09204062768384846 2025-03-05 14:00:02 1 (2,3.2) 0.15200169244542905 2025-03-05 14:00:02 -7 (5.5,4.7) 0.3503476876550442 2025-03-05 14:00:02 - Usearch: WHERE-type 2025-03-05 14:00:02 0 (4.6,2.3) 0.5527864045000421 2025-03-05 14:00:02 1 (2,3.2) 0.15200169244542905 2025-03-05 14:00:02 2 (4.2,3.4) 0.37080174340866845 2025-03-05 14:00:02 - Usearch: ORDER-BY-type 2025-03-05 14:00:02 6 (1,9.3) 0.005731362878640178 2025-03-05 14:00:02 +4 (2.4,5.2) 0.09204062768384846 2025-03-05 14:00:02 1 (2,3.2) 0.15200169244542905 2025-03-05 14:00:02 -7 (5.5,4.7) 0.3503476876550442 2025-03-05 14:00:02 - Special case: MaximumDistance is negative 2025-03-05 14:00:02 - Special case: MaximumDistance is negative 2025-03-05 14:00:02 - Special case: setting "annoy_index_search_k_nodes" 2025-03-05 14:00:02 +6 (1,9.3) 0.005731362878640178 2025-03-05 14:00:02 +4 (2.4,5.2) 0.09204062768384846 2025-03-05 14:00:02 +1 (2,3.2) 0.15200169244542905 2025-03-05 14:00:02 - Special case: setting "max_limit_for_ann_queries" 2025-03-05 14:00:02 -Expression (Projection) 2025-03-05 14:00:02 +Expression (Project names) 2025-03-05 14:00:02 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 14:00:02 Sorting (Sorting for ORDER BY) 2025-03-05 14:00:02 - Expression (Before ORDER BY) 2025-03-05 14:00:02 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2025-03-05 14:00:02 ReadFromMergeTree (default.tab_annoy) 2025-03-05 14:00:02 Indexes: 2025-03-05 14:00:02 PrimaryKey 2025-03-05 14:00:02 @@ -188,10 +151,10 @@ 2025-03-05 14:00:02 Parts: 1/1 2025-03-05 14:00:02 Granules: 4/4 2025-03-05 14:00:02 - Special case: setting "max_limit_for_ann_queries" 2025-03-05 14:00:02 -Expression (Projection) 2025-03-05 14:00:02 +Expression (Project names) 2025-03-05 14:00:02 Limit (preliminary LIMIT (without OFFSET)) 2025-03-05 14:00:02 Sorting (Sorting for ORDER BY) 2025-03-05 14:00:02 - Expression (Before ORDER BY) 2025-03-05 14:00:02 + Expression ((Before ORDER BY + (Projection + Change column names to column identifiers))) 2025-03-05 14:00:02 ReadFromMergeTree (default.tab_usearch) 2025-03-05 14:00:02 Indexes: 2025-03-05 14:00:02 PrimaryKey 2025-03-05 14:00:02 2025-03-05 14:00:02 2025-03-05 14:00:02 Settings used in the test: --max_insert_threads 13 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 1 --distributed_aggregation_memory_efficient 1 --fsync_metadata 1 --output_format_parallel_formatting 0 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 15603319 --max_read_buffer_size 930733 --prefer_localhost_replica 1 --max_block_size 98631 --max_threads 40 --optimize_append_index 0 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 1 --optimize_or_like_chain 0 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 14 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 17518045 --use_uncompressed_cache 1 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 1 --local_filesystem_read_method mmap --remote_filesystem_read_method threadpool --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 10 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 0 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 0 --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 24 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 2837484839 --min_compress_block_size 754858 --max_compress_block_size 1580109 --merge_tree_compact_parts_min_granules_to_multibuffer_read 55 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 8721939 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 0 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 3 --session_timezone America/Chicago --prefer_warmed_unmerged_parts_seconds 3 --use_page_cache_for_disks_without_file_cache False --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.68 2025-03-05 14:00:02 2025-03-05 14:00:02 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 4462287173 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 17510911 --merge_max_block_size 13019 --index_granularity 16946 --min_bytes_for_wide_part 1073741824 --marks_compress_block_size 76217 --primary_key_compress_block_size 73200 --replace_long_file_name_to_hash 1 --max_file_name_length 0 --min_bytes_for_full_part_storage 536870912 --compact_parts_max_bytes_to_buffer 401664169 --compact_parts_max_granules_to_buffer 9 --compact_parts_merge_max_bytes_to_prefetch_part 11242272 --cache_populated_by_fetch 1 --concurrent_part_removal_threshold 52 --old_parts_lifetime 382 2025-03-05 14:00:02 2025-03-05 14:00:02 Database: test_098huy7n 2025-03-05 14:00:05 02366_kql_func_ip: [ OK ] 8.48 sec. 2025-03-05 14:00:08 02377_optimize_sorting_by_input_stream_properties_explain: [ OK ] 18.87 sec. 2025-03-05 14:00:10 02352_lightweight_delete_on_replicated_merge_tree: [ OK ] 8.94 sec. 2025-03-05 14:00:11 02346_inverted_index_bug47393: [ OK ] 0.98 sec. 2025-03-05 14:00:12 02346_into_outfile_and_stdout: [ OK ] 4.23 sec. 2025-03-05 14:00:12 02346_position_countsubstrings_zero_byte: [ OK ] 1.07 sec. 2025-03-05 14:00:13 02346_inverted_index_bug52019: [ OK ] 0.72 sec. 2025-03-05 14:00:15 02345_partial_sort_transform_optimization: [ OK ] 2.16 sec. 2025-03-05 14:00:17 02370_lost_part_intersecting_merges: [ OK ] 20.64 sec. 2025-03-05 14:00:17 02343_create_empty_as_select: [ OK ] 0.70 sec. 2025-03-05 14:00:18 02343_group_by_use_nulls_distributed: [ OK ] 2.93 sec. 2025-03-05 14:00:18 02337_multiple_joins_original_names: [ OK ] 0.63 sec. 2025-03-05 14:00:18 02337_check_translate_qualified_names_matcher: [ OK ] 0.52 sec. 2025-03-05 14:00:19 02320_mapped_array_witn_const_nullable: [ OK ] 0.61 sec. 2025-03-05 14:00:19 02374_analyzer_join_using: [ OK ] 25.82 sec. 2025-03-05 14:00:22 02319_dict_get_check_arguments_size: [ OK ] 2.24 sec. 2025-03-05 14:00:22 02317_like_with_trailing_escape: [ OK ] 0.62 sec. 2025-03-05 14:00:23 02324_compatibility_setting: [ OK ] 4.83 sec. 2025-03-05 14:00:24 02317_functions_with_nothing: [ OK ] 0.77 sec. 2025-03-05 14:00:27 02316_hierarchical_dictionaries_nullable_parent_key: [ OK ] 3.23 sec. 2025-03-05 14:00:31 02316_expressions_with_window_functions: [ OK ] 4.17 sec. 2025-03-05 14:00:32 02316_cast_to_ip_address_default_column: [ OK ] 1.09 sec. 2025-03-05 14:00:33 02319_no_columns_in_row_level_filter: [ OK ] 13.82 sec. 2025-03-05 14:00:33 02311_range_hashed_dictionary_range_cast: [ OK ] 0.65 sec. 2025-03-05 14:00:33 02307_join_get_array_null: [ OK ] 0.42 sec. 2025-03-05 14:00:35 02310_profile_events_insert: [ OK ] 1.85 sec. 2025-03-05 14:00:36 02302_clash_const_aggegate_join: [ OK ] 0.92 sec. 2025-03-05 14:00:36 02296_nullable_arguments_in_array_filter: [ OK ] 0.61 sec. 2025-03-05 14:00:40 02305_schema_inference_with_globs: [ OK ] 6.36 sec. 2025-03-05 14:00:42 02317_distinct_in_order_optimization: [ OK ] 19.55 sec. 2025-03-05 14:00:43 02294_floating_point_second_in_settings: [ OK ] 6.22 sec. 2025-03-05 14:00:44 02294_nothing_arguments_in_functions_errors: [ OK ] 3.68 sec. 2025-03-05 14:00:45 02286_vertical_merges_missed_column: [ OK ] 2.03 sec. 2025-03-05 14:00:45 02291_join_const_literal_36279: [ OK ] 3.00 sec. 2025-03-05 14:00:45 02286_convert_decimal_type: [ OK ] 0.45 sec. 2025-03-05 14:00:46 02285_hex_bin_support_more_types: [ OK ] 0.75 sec. 2025-03-05 14:00:55 02270_errors_in_files: [ OK ] 8.53 sec. 2025-03-05 14:00:56 02347_rank_corr_size_overflow: [ OK ] 50.79 sec. 2025-03-05 14:00:57 02267_join_dup_columns_issue36199: [ OK ] 1.66 sec. 2025-03-05 14:00:58 02270_client_name: [ OK ] 3.09 sec. 2025-03-05 14:00:58 02250_insert_select_from_file_schema_inference: [ OK ] 0.47 sec. 2025-03-05 14:01:00 02346_inverted_index_search: [ OK ] 47.84 sec. 2025-03-05 14:01:00 02249_insert_select_from_input_schema_inference: [ OK ] 0.47 sec. 2025-03-05 14:01:02 02245_weird_partitions_pruning: [ OK ] 1.76 sec. 2025-03-05 14:01:03 02250_hints_for_columns: [ OK ] 4.14 sec. 2025-03-05 14:01:03 02244_ip_address_invalid_insert: [ OK ] 1.24 sec. 2025-03-05 14:01:04 02243_ipv6_long_parsing: [ OK ] 0.49 sec. 2025-03-05 14:01:04 02253_empty_part_checksums: [ OK ] 6.95 sec. 2025-03-05 14:01:04 02240_get_type_serialization_streams: [ OK ] 0.45 sec. 2025-03-05 14:01:05 02236_explain_pipeline_join: [ OK ] 0.49 sec. 2025-03-05 14:01:06 02243_arrow_read_null_type_to_nullable_column: [ OK ] 2.96 sec. 2025-03-05 14:01:06 02233_with_total_empty_chunk: [ OK ] 0.52 sec. 2025-03-05 14:01:08 02233_HTTP_ranged: [ OK ] 2.14 sec. 2025-03-05 14:01:09 02232_partition_pruner_single_point: [ OK ] 0.66 sec. 2025-03-05 14:01:10 02481_async_insert_dedup: [ OK ] 98.64 sec. 2025-03-05 14:01:10 02232_partition_pruner_mixed_constant_type: [ OK ] 0.90 sec. 2025-03-05 14:01:11 02352_lightweight_delete: [ OK ] 68.58 sec. 2025-03-05 14:01:11 02231_hierarchical_dictionaries_constant: [ OK ] 1.01 sec. 2025-03-05 14:01:13 02286_parallel_final: [ OK ] 28.20 sec. 2025-03-05 14:01:13 02226_low_cardinality_text_bloom_filter_index: [ OK ] 2.26 sec. 2025-03-05 14:01:14 02227_test_create_empty_sqlite_db: [ OK ] 2.73 sec. 2025-03-05 14:01:14 02226_in_untuple_issue_34810: [ OK ] 0.82 sec. 2025-03-05 14:01:14 02224_s2_test_const_columns: [ OK ] 0.78 sec. 2025-03-05 14:01:15 02210_append_to_dev_dull: [ OK ] 0.85 sec. 2025-03-05 14:01:15 02209_short_circuit_node_without_parents: [ OK ] 0.53 sec. 2025-03-05 14:01:16 02240_protobuflist_format_persons: [ OK ] 11.32 sec. 2025-03-05 14:01:16 02223_h3_test_const_columns: [ OK ] 2.32 sec. 2025-03-05 14:01:16 02235_brotli_bug: [ OK ] 11.28 sec. 2025-03-05 14:01:17 02207_key_condition_floats: [ OK ] 1.35 sec. 2025-03-05 14:01:17 02206_clickhouse_local_use_database: [ OK ] 1.70 sec. 2025-03-05 14:01:17 02967_parallel_replicas_join_algo_and_analyzer: [ OK ] 175.58 sec. 2025-03-05 14:01:18 02205_HTTP_user_agent: [ OK ] 1.42 sec. 2025-03-05 14:01:18 02190_current_metrics_query: [ OK ] 0.42 sec. 2025-03-05 14:01:18 02187_test_final_and_limit_modifier: [ OK ] 0.59 sec. 2025-03-05 14:01:18 02184_ipv6_select_parsing: [ OK ] 0.50 sec. 2025-03-05 14:01:18 02184_ipv6_cast_test: [ OK ] 0.44 sec. 2025-03-05 14:01:19 02205_postgresql_functions: [ OK ] 1.72 sec. 2025-03-05 14:01:19 02186_range_hashed_dictionary_intersecting_intervals: [ OK ] 0.95 sec. 2025-03-05 14:01:19 02210_processors_profile_log_2: [ OK ] 5.08 sec. 2025-03-05 14:01:19 02206_format_override: [ OK ] 3.14 sec. 2025-03-05 14:01:20 02167_columns_with_dots_default_values: [ OK ] 0.61 sec. 2025-03-05 14:01:20 02165_h3_exact_edge_length_Km: [ OK ] 0.65 sec. 2025-03-05 14:01:20 02179_bool_type: [ OK ] 1.31 sec. 2025-03-05 14:01:20 02183_array_tuple_literals_remote: [ OK ] 1.62 sec. 2025-03-05 14:01:20 02179_sparse_columns_detach: [ OK ] 1.59 sec. 2025-03-05 14:01:20 02176_dict_get_has_implicit_key_cast: [ OK ] 1.68 sec. 2025-03-05 14:01:20 02165_h3_exact_edge_length_m: [ OK ] 0.61 sec. 2025-03-05 14:01:21 02162_range_hashed_dictionary_ddl_expression: [ OK ] 0.57 sec. 2025-03-05 14:01:21 02160_h3_cell_area_m2: [ OK ] 0.70 sec. 2025-03-05 14:01:21 02163_shard_num: [ OK ] 1.00 sec. 2025-03-05 14:01:21 02160_h3_cell_area_rads2: [ OK ] 0.62 sec. 2025-03-05 14:01:21 02160_special_functions: [ OK ] 0.81 sec. 2025-03-05 14:01:22 02160_h3_hex_area_Km2: [ OK ] 0.58 sec. 2025-03-05 14:01:22 02158_contingency: [ OK ] 0.67 sec. 2025-03-05 14:01:23 02165_replicated_grouping_sets: [ OK ] 3.48 sec. 2025-03-05 14:01:23 02155_h3_to_center_child: [ OK ] 1.97 sec. 2025-03-05 14:01:23 02153_clickhouse_local_profile_info: [ OK ] 1.52 sec. 2025-03-05 14:01:24 02160_client_autocomplete_parse_query: [ OK ] 2.74 sec. 2025-03-05 14:01:24 02152_csv_tuple: [ OK ] 0.61 sec. 2025-03-05 14:01:24 02160_untuple_exponential_growth: [ OK ] 3.67 sec. 2025-03-05 14:01:25 02151_clickhouse_client_hints: [ OK ] 1.43 sec. 2025-03-05 14:01:25 02131_remove_columns_in_subquery: [ OK ] 0.57 sec. 2025-03-05 14:01:26 02136_kill_scalar_queries: [ OK ] 2.03 sec. 2025-03-05 14:01:26 02135_local_create_db: [ OK ] 1.82 sec. 2025-03-05 14:01:27 02125_constant_if_condition_and_not_existing_column: [ OK ] 0.68 sec. 2025-03-05 14:01:27 02126_url_auth: [ OK ] 1.73 sec. 2025-03-05 14:01:29 02125_query_views_log: [ OK ] 1.97 sec. 2025-03-05 14:01:29 02124_encrypt_decrypt_nullable: [ OK ] 0.61 sec. 2025-03-05 14:01:30 02154_parser_backtracking: [ FAIL ] 8.04 sec. - return code: 1 2025-03-05 14:01:30 Code: 306. DB::Exception: Stack size too large. Stack address: 0x7ffe4f59f000, frame address: 0x7ffe4fd32de0, stack size: 418336, maximum stack size: 8364032. (TOO_DEEP_RECURSION) 2025-03-05 14:01:30 Code: 306. DB::Exception: Stack size too large. Stack address: 0x7ffef4cd1000, frame address: 0x7ffef5465c20, stack size: 418784, maximum stack size: 8368128. (TOO_DEEP_RECURSION) 2025-03-05 14:01:30 , result: 2025-03-05 14:01:30 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 0 2025-03-05 14:01:30 2025-03-05 14:01:30 stdout: 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 1 2025-03-05 14:01:30 0 2025-03-05 14:01:30 2025-03-05 14:01:30 2025-03-05 14:01:30 Settings used in the test: --max_insert_threads 0 --group_by_two_level_threshold 1000000 --group_by_two_level_threshold_bytes 44896689 --distributed_aggregation_memory_efficient 1 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 6774611 --max_read_buffer_size 940991 --prefer_localhost_replica 0 --max_block_size 88908 --max_threads 39 --optimize_append_index 1 --optimize_if_chain_to_multiif 1 --optimize_if_transform_strings_to_enum 1 --optimize_read_in_order 0 --optimize_or_like_chain 0 --optimize_substitute_columns 0 --enable_multiple_prewhere_read_steps 1 --read_in_order_two_level_merge_threshold 57 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 48750154 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 1 --min_bytes_to_use_mmap_io 10737418240 --local_filesystem_read_method mmap --remote_filesystem_read_method read --local_filesystem_read_prefetch 0 --filesystem_cache_segments_batch_size 10 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 1 --throw_on_error_from_cache_on_write_operations 1 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 0 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 10 --filesystem_prefetch_min_bytes_for_single_read_task 1Mi --filesystem_prefetch_step_marks 0 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 28 --optimize_distinct_in_order 0 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10471482797 --max_bytes_before_remerge_sort 2007985587 --min_compress_block_size 1203673 --max_compress_block_size 2714445 --merge_tree_compact_parts_min_granules_to_multibuffer_read 110 --optimize_sorting_by_input_stream_properties 0 --http_response_buffer_size 4392355 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 0 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 0 --min_count_to_compile_sort_description 3 --session_timezone America/Mazatlan --prefer_warmed_unmerged_parts_seconds 0 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.7 2025-03-05 14:01:30 2025-03-05 14:01:30 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 1.0 --prefer_fetch_merged_part_size_threshold 10737418240 --vertical_merge_algorithm_min_rows_to_activate 762270 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 0 --min_merge_bytes_to_use_direct_io 10737418240 --index_granularity_bytes 2839830 --merge_max_block_size 18455 --index_granularity 3440 --min_bytes_for_wide_part 291489611 --marks_compress_block_size 84034 --primary_key_compress_block_size 66015 --replace_long_file_name_to_hash 1 --max_file_name_length 128 --min_bytes_for_full_part_storage 128284126 --compact_parts_max_bytes_to_buffer 364962499 --compact_parts_max_granules_to_buffer 46 --compact_parts_merge_max_bytes_to_prefetch_part 14198420 --cache_populated_by_fetch 0 --concurrent_part_removal_threshold 100 --old_parts_lifetime 116 2025-03-05 14:01:30 2025-03-05 14:01:30 Database: test_3m3r8h5m 2025-03-05 14:01:30 02123_MySQLWire_regression: [ OK ] 0.43 sec. 2025-03-05 14:01:30 02151_http_s_structure_set_eof: [ OK ] 6.45 sec. 2025-03-05 14:01:30 02149_schema_inference_formats_with_schema_3: [ OK ] 6.30 sec. 2025-03-05 14:01:34 02124_insert_deduplication_token_multiple_blocks: [ OK ] 6.81 sec. 2025-03-05 14:01:37 02122_parallel_formatting_Template: [ OK ] 7.12 sec. 2025-03-05 14:01:38 02122_parallel_formatting_CSVWithNamesAndTypes: [ OK ] 7.74 sec. 2025-03-05 14:01:38 02118_show_create_table_rocksdb: [ OK ] 0.39 sec. 2025-03-05 14:01:39 02122_parallel_formatting_JSONStrings: [ OK ] 9.11 sec. 2025-03-05 14:01:40 02116_interactive_hello: [ OK ] 1.59 sec. 2025-03-05 14:01:40 02113_format_row_bug: [ OK ] 1.13 sec. 2025-03-05 14:01:40 02113_format_row: [ OK ] 0.57 sec. 2025-03-05 14:01:42 02112_delayed_clickhouse_local_with_queries_file: [ OK ] 1.48 sec. 2025-03-05 14:01:42 02122_parallel_formatting_JSONStringsEachRow: [ OK ] 12.18 sec. 2025-03-05 14:01:43 02111_global_context_temporary_tables: [ OK ] 0.93 sec. 2025-03-05 14:01:43 02111_with_fill_no_rows: [ OK ] 1.13 sec. 2025-03-05 14:01:44 02112_with_fill_interval: [ OK ] 3.64 sec. 2025-03-05 14:01:44 02104_clickhouse_local_columns_description: [ OK ] 1.43 sec. 2025-03-05 14:01:46 02100_alter_scalar_circular_deadlock: [ OK ] 2.21 sec. 2025-03-05 14:01:47 02125_lz4_compression_bug_JSONStringsEachRow: [ OK ] 20.71 sec. 2025-03-05 14:01:47 02096_totals_global_in_bug: [ OK ] 0.72 sec. 2025-03-05 14:01:47 02071_lower_upper_utf8_row_overlaps: [ OK ] 0.52 sec. 2025-03-05 14:01:48 02122_parallel_formatting_JSONCompactEachRow: [ OK ] 10.91 sec. 2025-03-05 14:01:48 02097_json_strings_deserialization: [ OK ] 3.96 sec. 2025-03-05 14:01:48 02047_alias_for_table_and_database_name: [ OK ] 0.43 sec. 2025-03-05 14:01:49 02041_test_fuzzy_alter: [ OK ] 0.50 sec. 2025-03-05 14:01:49 02052_last_granula_adjust_logical_error: [ OK ] 2.02 sec. 2025-03-05 14:01:50 02036_jit_short_circuit: [ OK ] 0.54 sec. 2025-03-05 14:01:50 02041_openssl_hash_functions_test: [ OK ] 0.56 sec. 2025-03-05 14:01:50 02029_output_csv_null_representation: [ OK ] 0.48 sec. 2025-03-05 14:01:51 02026_describe_include_subcolumns: [ OK ] 0.47 sec. 2025-03-05 14:01:53 02122_4letter_words_stress_zookeeper: [ OK ] 19.44 sec. 2025-03-05 14:01:56 02047_log_family_data_file_sizes: [ OK ] 8.55 sec. 2025-03-05 14:01:56 02022_bzip2_truncated: [ OK ] 2.67 sec. 2025-03-05 14:01:56 02021_h3_is_res_classIII: [ OK ] 0.48 sec. 2025-03-05 14:01:57 02020_cast_integer_overflow: [ OK ] 0.42 sec. 2025-03-05 14:01:57 02020_exponential_smoothing_cross_block: [ OK ] 0.43 sec. 2025-03-05 14:01:57 02047_log_family_data_file_dumps: [ OK ] 9.03 sec. 2025-03-05 14:01:58 02025_storage_filelog_virtual_col: [ OK ] 6.90 sec. 2025-03-05 14:01:58 02033_join_engine_deadlock_long: [ OK ] 7.99 sec. 2025-03-05 14:01:58 02017_order_by_with_fill_redundant_functions: [ OK ] 0.43 sec. 2025-03-05 14:01:58 02016_agg_empty_result_bug_28880: [ OK ] 0.50 sec. 2025-03-05 14:01:59 02012_settings_clause_for_s3: [ OK ] 0.51 sec. 2025-03-05 14:01:59 02102_row_binary_with_names_and_types: [ OK ] 15.99 sec. 2025-03-05 14:01:59 02017_bit_shift_left_for_string_integer: [ OK ] 2.41 sec. 2025-03-05 14:02:00 02006_h3_to_geo_boundary: [ OK ] 0.78 sec. 2025-03-05 14:02:00 02007_test_any_all_operators: [ OK ] 1.31 sec. 2025-03-05 14:02:00 02016_aggregation_spark_bar: [ OK ] 2.81 sec. 2025-03-05 14:02:00 02015_async_inserts_1: [ OK ] 2.59 sec. 2025-03-05 14:02:01 02002_parse_map_int_key: [ OK ] 0.45 sec. 2025-03-05 14:02:01 02001_select_with_filter: [ OK ] 0.53 sec. 2025-03-05 14:02:01 02000_table_function_cluster_macros: [ OK ] 0.56 sec. 2025-03-05 14:02:01 02001_dist_on_dist_WithMergeableStateAfterAggregation: [ OK ] 0.80 sec. 2025-03-05 14:02:02 01948_heredoc: [ OK ] 0.58 sec. 2025-03-05 14:02:02 02003_compress_bz2: [ OK ] 2.06 sec. 2025-03-05 14:02:02 02006_test_positional_arguments: [ OK ] 2.86 sec. 2025-03-05 14:02:02 01937_nested_chinese: [ OK ] 0.51 sec. 2025-03-05 14:02:03 02020_exponential_smoothing: [ OK ] 5.90 sec. 2025-03-05 14:02:03 01949_heredoc_unfinished: [ OK ] 1.48 sec. 2025-03-05 14:02:03 01925_date_date_time_comparison: [ OK ] 0.40 sec. 2025-03-05 14:02:03 01922_array_join_with_index: [ OK ] 0.46 sec. 2025-03-05 14:02:03 01944_insert_partition_by: [ OK ] 1.35 sec. 2025-03-05 14:02:03 01917_system_data_skipping_indices: [ OK ] 0.64 sec. 2025-03-05 14:02:04 01916_multiple_join_view_optimize_predicate_chertus: [ OK ] 0.60 sec. 2025-03-05 14:02:04 01915_merge_prewhere_virtual_column_rand_chao_wang: [ OK ] 0.63 sec. 2025-03-05 14:02:04 01913_if_int_decimal: [ OK ] 0.40 sec. 2025-03-05 14:02:04 01913_join_push_down_bug: [ OK ] 0.50 sec. 2025-03-05 14:02:05 01915_for_each_crakjie: [ OK ] 0.97 sec. 2025-03-05 14:02:05 01925_join_materialized_columns: [ OK ] 2.26 sec. 2025-03-05 14:02:05 01910_memory_tracking_topk: [ OK ] 0.72 sec. 2025-03-05 14:02:05 01905_to_json_string: [ OK ] 0.63 sec. 2025-03-05 14:02:05 01909_mbtolou: [ OK ] 0.86 sec. 2025-03-05 14:02:05 01949_clickhouse_local_with_remote_localhost: [ OK ] 4.40 sec. 2025-03-05 14:02:06 01891_partition_by_uuid: [ OK ] 0.50 sec. 2025-03-05 14:02:06 01891_partition_hash_no_long_int: [ OK ] 0.79 sec. 2025-03-05 14:02:06 01890_stem: [ OK ] 0.72 sec. 2025-03-05 14:02:06 01921_datatype_date32: [ OK ] 3.64 sec. 2025-03-05 14:02:07 01883_subcolumns_distributed: [ OK ] 1.13 sec. 2025-03-05 14:02:08 01888_read_int_safe: [ OK ] 1.51 sec. 2025-03-05 14:02:08 01888_bloom_filter_hasAny: [ OK ] 1.51 sec. 2025-03-05 14:02:08 01881_aggregate_functions_versioning: [ OK ] 0.49 sec. 2025-03-05 14:02:08 01882_scalar_subquery_exception: [ OK ] 0.70 sec. 2025-03-05 14:02:08 01881_total_bytes_storage_buffer: [ OK ] 0.59 sec. 2025-03-05 14:02:09 01892_jit_aggregation_function_any_last_long: [ OK ] 3.64 sec. 2025-03-05 14:02:09 01869_function_modulo_legacy: [ OK ] 0.46 sec. 2025-03-05 14:02:10 01854_s2_cap_contains: [ OK ] 1.10 sec. 2025-03-05 14:02:10 01852_multiple_joins_with_union_join: [ OK ] 0.75 sec. 2025-03-05 14:02:11 01860_Distributed__shard_num_GROUP_BY: [ OK ] 2.15 sec. 2025-03-05 14:02:11 01851_hedged_connections_external_tables: [ SKIPPED ] 0.00 sec. - not running for current build 2025-03-05 14:02:11 01851_s2_to_geo: [ OK ] 0.44 sec. 2025-03-05 14:02:11 01854_HTTP_dict_decompression: [ OK ] 2.38 sec. 2025-03-05 14:02:12 01845_add_testcase_for_arrayElement: [ OK ] 0.53 sec. 2025-03-05 14:02:12 01871_merge_tree_compile_expressions: [ OK ] 3.47 sec. 2025-03-05 14:02:12 01835_alias_to_primary_key_cyfdecyf: [ OK ] 0.48 sec. 2025-03-05 14:02:12 01849_geoToS2: [ OK ] 1.47 sec. 2025-03-05 14:02:12 01831_max_streams: [ OK ] 0.51 sec. 2025-03-05 14:02:12 01893_jit_aggregation_function_min_long: [ OK ] 7.71 sec. 2025-03-05 14:02:13 01825_type_json_9: [ OK ] 0.60 sec. 2025-03-05 14:02:15 01825_type_json_7: [ OK ] 3.05 sec. 2025-03-05 14:02:16 01825_type_json_16: [ OK ] 3.72 sec. 2025-03-05 14:02:16 01825_type_json_12: [ OK ] 3.56 sec. 2025-03-05 14:02:17 01825_type_json_schema_inference: [ OK ] 4.88 sec. 2025-03-05 14:02:17 01825_type_json_2: [ OK ] 1.03 sec. 2025-03-05 14:02:17 01825_type_json_sparse: [ OK ] 0.99 sec. 2025-03-05 14:02:18 01825_type_json_nullable: [ OK ] 0.67 sec. 2025-03-05 14:02:18 01821_to_date_time_ubsan: [ OK ] 0.45 sec. 2025-03-05 14:02:18 01818_case_float_value_fangyc: [ OK ] 0.38 sec. 2025-03-05 14:02:19 01818_move_partition_simple: [ OK ] 1.00 sec. 2025-03-05 14:02:19 01889_sqlite_read_write: [ OK ] 13.28 sec. 2025-03-05 14:02:19 01811_filter_by_null: [ OK ] 0.54 sec. 2025-03-05 14:02:20 01804_uniq_up_to_ubsan: [ OK ] 0.44 sec. 2025-03-05 14:02:20 01802_rank_corr_mann_whitney_over_window: [ OK ] 0.60 sec. 2025-03-05 14:02:21 01809_inactive_parts_to_delay_throw_insert: [ OK ] 1.50 sec. 2025-03-05 14:02:21 01825_type_json_btc: [ OK ] 4.64 sec. 2025-03-05 14:02:21 01801_distinct_group_by_shard: [ OK ] 0.51 sec. 2025-03-05 14:02:22 01795_TinyLog_rwlock_ub: [ OK ] 0.62 sec. 2025-03-05 14:02:22 01812_basic_auth_http_server: [ OK ] 4.04 sec. 2025-03-05 14:02:24 01780_column_sparse_pk: [ OK ] 1.41 sec. 2025-03-05 14:02:24 01801_s3_cluster: [ OK ] 3.44 sec. 2025-03-05 14:02:24 01779_quantile_deterministic_msan: [ OK ] 0.45 sec. 2025-03-05 14:02:24 01780_column_sparse: [ OK ] 0.92 sec. 2025-03-05 14:02:25 01776_decrypt_aead_size_check: [ OK ] 0.47 sec. 2025-03-05 14:02:25 01778_where_with_column_name: [ OK ] 0.54 sec. 2025-03-05 14:02:25 01786_nullable_string_tsv_at_eof: [ OK ] 3.14 sec. 2025-03-05 14:02:25 01774_case_sensitive_connection_id: [ OK ] 0.41 sec. 2025-03-05 14:02:26 01773_datetime64_add_ubsan: [ OK ] 0.47 sec. 2025-03-05 14:02:26 01798_uniq_theta_sketch: [ OK ] 4.37 sec. 2025-03-05 14:02:26 01771_datetime64_no_time_part: [ OK ] 0.53 sec. 2025-03-05 14:02:26 01761_round_year_bounds: [ OK ] 0.41 sec. 2025-03-05 14:02:26 01764_collapsing_merge_adaptive_granularity: [ OK ] 0.91 sec. 2025-03-05 14:02:27 01752_distributed_query_sigsegv: [ OK ] 0.89 sec. 2025-03-05 14:02:27 01753_optimize_aggregation_in_order: [ OK ] 1.68 sec. 2025-03-05 14:02:28 01753_fix_clickhouse_format: [ OK ] 1.92 sec. 2025-03-05 14:02:28 01732_bigint_ubsan: [ OK ] 0.71 sec. 2025-03-05 14:02:29 01739_index_hint: [ OK ] 1.62 sec. 2025-03-05 14:02:29 01717_global_with_subquery_fix: [ OK ] 0.51 sec. 2025-03-05 14:02:29 01746_test_for_tupleElement_must_be_constant_issue: [ OK ] 2.90 sec. 2025-03-05 14:02:29 01720_constraints_complex_types: [ OK ] 1.08 sec. 2025-03-05 14:02:30 01715_table_function_view_fix: [ OK ] 0.53 sec. 2025-03-05 14:02:30 01711_decimal_multiplication: [ OK ] 0.47 sec. 2025-03-05 14:02:30 01710_projection_in_index: [ OK ] 0.74 sec. 2025-03-05 14:02:31 01710_projection_with_mixed_pipeline: [ OK ] 0.84 sec. 2025-03-05 14:02:31 01710_projections_and_duplicate_columms: [ OK ] 1.24 sec. 2025-03-05 14:02:31 01710_projection_in_set: [ OK ] 1.06 sec. 2025-03-05 14:02:33 01710_projection_aggregation_in_order: [ OK ] 2.36 sec. 2025-03-05 14:02:33 01710_projection_query_plan_optimization_misc: [ OK ] 0.51 sec. 2025-03-05 14:02:34 01825_type_json_ghdata: [ OK ] 19.61 sec. 2025-03-05 14:02:35 01710_projections: [ OK ] 3.38 sec. 2025-03-05 14:02:35 01710_projection_external_aggregate: [ OK ] 1.30 sec. 2025-03-05 14:02:35 01710_minmax_count_projection_count_nullable: [ OK ] 0.57 sec. 2025-03-05 14:02:35 01710_projection_group_by_order_by: [ OK ] 0.42 sec. 2025-03-05 14:02:35 01710_projection_analysis_reuse_partition: [ OK ] 4.00 sec. 2025-03-05 14:02:35 01704_transform_with_float_key: [ OK ] 0.46 sec. 2025-03-05 14:02:36 01710_projections_order_by_complete: [ OK ] 0.62 sec. 2025-03-05 14:02:36 01707_join_use_nulls: [ OK ] 0.74 sec. 2025-03-05 14:02:36 01702_rewrite_avg_for_algebraic_optimization: [ OK ] 1.00 sec. 2025-03-05 14:02:37 01701_clear_projection_and_part_remove: [ OK ] 1.01 sec. 2025-03-05 14:02:37 01720_country_intersection: [ OK ] 8.87 sec. 2025-03-05 14:02:37 01683_dist_INSERT_block_structure_mismatch: [ OK ] 0.59 sec. 2025-03-05 14:02:37 01701_if_tuple_segfault: [ OK ] 1.54 sec. 2025-03-05 14:02:37 01683_intdiv_ubsan: [ OK ] 0.49 sec. 2025-03-05 14:02:38 01677_array_enumerate_bug: [ OK ] 0.44 sec. 2025-03-05 14:02:38 01681_bloom_filter_nullable_column: [ OK ] 1.28 sec. 2025-03-05 14:02:38 01677_bit_float: [ OK ] 1.39 sec. 2025-03-05 14:02:39 01676_reinterpret_as: [ OK ] 1.17 sec. 2025-03-05 14:02:39 01674_where_prewhere_array_crash: [ OK ] 0.61 sec. 2025-03-05 14:02:39 01671_test_toQuarter_mysql_dialect: [ OK ] 0.39 sec. 2025-03-05 14:02:39 01681_hyperscan_debug_assertion: [ OK ] 2.55 sec. 2025-03-05 14:02:39 01670_test_repeat_mysql_dialect: [ OK ] 0.43 sec. 2025-03-05 14:02:39 01666_date_lut_buffer_overflow: [ OK ] 0.38 sec. 2025-03-05 14:02:40 01662_join_mixed: [ OK ] 0.47 sec. 2025-03-05 14:02:40 01665_running_difference_ubsan: [ OK ] 0.45 sec. 2025-03-05 14:02:40 01669_join_or_duplicates: [ OK ] 0.98 sec. 2025-03-05 14:02:40 01691_parser_data_type_exponential: [ OK ] 4.18 sec. 2025-03-05 14:02:40 01660_second_extremes_bug: [ OK ] 0.50 sec. 2025-03-05 14:02:40 01656_ipv4_bad_formatting: [ OK ] 0.41 sec. 2025-03-05 14:02:41 01660_sum_ubsan: [ OK ] 0.86 sec. 2025-03-05 14:02:41 01655_sleep_infinite_float: [ OK ] 0.46 sec. 2025-03-05 14:02:41 01661_week_functions_string_args: [ OK ] 1.91 sec. 2025-03-05 14:02:41 01656_join_defaul_enum: [ OK ] 1.11 sec. 2025-03-05 14:02:42 01655_test_isnull_mysql_dialect: [ OK ] 0.41 sec. 2025-03-05 14:02:42 01659_h3_buffer_overflow: [ OK ] 1.96 sec. 2025-03-05 14:02:46 01648_mutations_and_escaping: [ OK ] 4.21 sec. 2025-03-05 14:02:47 01646_rewrite_sum_if_bug: [ OK ] 1.15 sec. 2025-03-05 14:02:48 01644_distributed_async_insert_fsync_smoke: [ OK ] 1.14 sec. 2025-03-05 14:02:50 01642_if_nullable_regression: [ OK ] 1.24 sec. 2025-03-05 14:02:50 01640_distributed_async_insert_compression: [ OK ] 0.63 sec. 2025-03-05 14:02:51 01638_div_mod_ambiguities: [ OK ] 0.57 sec. 2025-03-05 14:02:52 01635_sum_map_fuzz: [ OK ] 0.59 sec. 2025-03-05 14:02:52 01633_limit_fuzz: [ OK ] 0.50 sec. 2025-03-05 14:02:53 01632_select_all_syntax: [ OK ] 0.86 sec. 2025-03-05 14:02:53 01656_sequence_next_node_long: [ OK ] 12.99 sec. 2025-03-05 14:02:54 01630_simple_aggregate_function_in_summing_merge_tree: [ OK ] 0.88 sec. 2025-03-05 14:02:59 01654_test_writer_block_sequence: [ OK ] 17.43 sec. 2025-03-05 14:03:01 01651_bugs_from_15889: [ OK ] 19.68 sec. 2025-03-05 14:03:06 01622_codec_zstd_long: [ OK ] 4.28 sec. 2025-03-05 14:03:06 01621_decode_XML: [ OK ] 0.59 sec. 2025-03-05 14:03:09 01825_type_json_ghdata_insert_select: [ OK ] 56.87 sec. 2025-03-05 14:03:09 01605_adaptive_granularity_block_borders: [ SKIPPED ] 0.00 sec. - not running for current build 2025-03-05 14:03:09 01603_read_with_backoff_bug: [ SKIPPED ] 0.00 sec. - not running for current build 2025-03-05 14:03:09 01607_arrays_as_nested_csv: [ OK ] 2.90 sec. 2025-03-05 14:03:10 01602_insert_into_table_function_cluster: [ OK ] 1.23 sec. 2025-03-05 14:03:11 01623_constraints_column_swap: [ OK ] 11.95 sec. 2025-03-05 14:03:12 01599_multiline_input_and_singleline_comments: [ OK ] 1.25 sec. 2025-03-05 14:03:13 01600_quota_by_forwarded_ip: [ OK ] 2.21 sec. 2025-03-05 14:03:13 01594_storage_join_uuid: [ OK ] 0.51 sec. 2025-03-05 14:03:14 01592_toUnixTimestamp_Date: [ OK ] 0.50 sec. 2025-03-05 14:03:14 01603_insert_select_too_many_parts: [ OK ] 4.82 sec. 2025-03-05 14:03:15 01585_use_index_for_global_in: [ OK ] 0.76 sec. 2025-03-05 14:03:15 01599_mutation_query_params: [ OK ] 3.24 sec. 2025-03-05 14:03:16 01582_move_to_prewhere_compact_parts: [ OK ] 0.69 sec. 2025-03-05 14:03:19 01581_deduplicate_by_columns_local: [ OK ] 2.51 sec. 2025-03-05 14:03:23 01568_window_functions_distributed: [ OK ] 4.42 sec. 2025-03-05 14:03:24 01591_window_functions: [ OK ] 9.75 sec. 2025-03-05 14:03:24 01561_aggregate_functions_of_key_with_join: [ OK ] 0.56 sec. 2025-03-05 14:03:25 01558_enum_as_num_in_tsv_csv_input: [ OK ] 0.65 sec. 2025-03-05 14:03:26 01561_mann_whitney_scipy: [ OK ] 3.15 sec. 2025-03-05 14:03:27 01533_collate_in_nullable: [ OK ] 0.56 sec. 2025-03-05 14:03:27 01583_parallel_parsing_exception_with_offset: [ OK ] 12.10 sec. 2025-03-05 14:03:28 01528_allow_nondeterministic_optimize_skip_unused_shards: [ OK ] 0.75 sec. 2025-03-05 14:03:28 01550_query_identifier_parameters: [ OK ] 3.03 sec. 2025-03-05 14:03:28 01528_play: [ OK ] 1.15 sec. 2025-03-05 14:03:29 01525_select_with_offset_fetch_clause: [ OK ] 0.63 sec. 2025-03-05 14:03:29 01519_topK_distributed_parametrized: [ OK ] 0.79 sec. 2025-03-05 14:03:30 01520_client_print_query_id: [ OK ] 1.54 sec. 2025-03-05 14:03:30 01514_input_format_tsv_enum_as_number_setting: [ OK ] 0.51 sec. 2025-03-05 14:03:30 01515_force_data_skipping_indices: [ OK ] 0.94 sec. 2025-03-05 14:03:31 01512_create_replicate_merge_tree_one_arg: [ OK ] 0.44 sec. 2025-03-05 14:03:31 01514_empty_buffer_different_types: [ OK ] 0.61 sec. 2025-03-05 14:03:31 01523_client_local_queries_file_parameter: [ OK ] 3.04 sec. 2025-03-05 14:03:32 01511_alter_version_versioned_collapsing_merge_tree: [ OK ] 1.32 sec. 2025-03-05 14:03:33 01509_dictionary_preallocate: [ OK ] 1.72 sec. 2025-03-05 14:03:34 01508_query_obfuscator: [ OK ] 1.47 sec. 2025-03-05 14:03:35 01509_check_parallel_quorum_inserts_long: [ OK ] 3.88 sec. 2025-03-05 14:03:36 01505_distributed_local_type_conversion_enum: [ OK ] 0.82 sec. 2025-03-05 14:03:37 01503_if_const_optimization: [ OK ] 0.93 sec. 2025-03-05 14:03:37 01502_jemalloc_percpu_arena: [ SKIPPED ] 0.00 sec. - not running for current build 2025-03-05 14:03:37 01508_format_regexp_raw: [ OK ] 2.76 sec. 2025-03-05 14:03:38 01496_signedness_conversion_monotonicity: [ OK ] 0.66 sec. 2025-03-05 14:03:38 01493_table_function_null: [ OK ] 0.48 sec. 2025-03-05 14:03:39 01492_array_join_crash_13829: [ OK ] 0.40 sec. 2025-03-05 14:03:39 01490_nullable_string_to_enum: [ OK ] 0.63 sec. 2025-03-05 14:03:39 01485_256_bit_multiply: [ SKIPPED ] 0.00 sec. - not running for current build 2025-03-05 14:03:40 01476_right_full_join_switch: [ OK ] 1.22 sec. 2025-03-05 14:03:41 01475_read_subcolumns_2: [ OK ] 0.88 sec. 2025-03-05 14:03:42 01473_system_events_zeroes: [ OK ] 0.38 sec. 2025-03-05 14:03:42 01472_many_rows_in_totals: [ OK ] 0.58 sec. 2025-03-05 14:03:43 01470_columns_transformers2: [ OK ] 0.48 sec. 2025-03-05 14:03:43 01502_bar_overflow: [ OK ] 6.50 sec. 2025-03-05 14:03:43 01463_resample_overflow: [ OK ] 0.53 sec. 2025-03-05 14:03:44 01509_check_many_parallel_quorum_inserts_long: [ OK ] 11.44 sec. 2025-03-05 14:03:44 01456_min_negative_decimal_formatting: [ OK ] 0.43 sec. 2025-03-05 14:03:44 01455_default_compression: [ OK ] 0.63 sec. 2025-03-05 14:03:44 01456_low_cardinality_sorting_bugfix: [ OK ] 1.02 sec. 2025-03-05 14:03:45 01453_fixsed_string_sort: [ OK ] 0.70 sec. 2025-03-05 14:03:45 01452_normalized_query_hash: [ OK ] 0.52 sec. 2025-03-05 14:03:45 01450_set_null_const: [ OK ] 0.60 sec. 2025-03-05 14:03:45 01434_netloc_fuzz: [ OK ] 0.52 sec. 2025-03-05 14:03:45 01430_moving_sum_empty_state: [ OK ] 0.64 sec. 2025-03-05 14:03:46 01427_pk_and_expression_with_different_type: [ OK ] 0.47 sec. 2025-03-05 14:03:46 01421_array_nullable_element_nullable_index: [ OK ] 0.48 sec. 2025-03-05 14:03:46 01425_decimal_parse_big_negative_exponent: [ OK ] 0.85 sec. 2025-03-05 14:03:47 01428_nullable_asof_join: [ OK ] 1.40 sec. 2025-03-05 14:03:47 01418_index_analysis_bug: [ OK ] 0.88 sec. 2025-03-05 14:03:47 01418_custom_settings: [ OK ] 1.29 sec. 2025-03-05 14:03:48 01416_join_totals_header_bug: [ OK ] 0.74 sec. 2025-03-05 14:03:49 01413_allow_non_metadata_alters: [ OK ] 0.63 sec. 2025-03-05 14:03:49 01412_optimize_deduplicate_bug: [ OK ] 0.60 sec. 2025-03-05 14:03:50 01412_mod_float: [ OK ] 0.53 sec. 2025-03-05 14:03:51 01407_lambda_arrayJoin: [ OK ] 0.77 sec. 2025-03-05 14:03:51 01630_simple_aggregate_all_functions_in_aggregating_merge_tree: [ OK ] 57.93 sec. 2025-03-05 14:03:52 01402_cast_nullable_string_to_enum: [ OK ] 0.92 sec. 2025-03-05 14:03:52 01396_low_cardinality_fixed_string_default: [ OK ] 0.63 sec. 2025-03-05 14:03:52 01417_query_time_in_system_events: [ OK ] 5.53 sec. 2025-03-05 14:03:52 01381_for_each_with_states: [ OK ] 0.70 sec. 2025-03-05 14:03:53 01384_bloom_filter_bad_arguments: [ OK ] 1.02 sec. 2025-03-05 14:03:53 01414_low_cardinality_nullable: [ OK ] 5.48 sec. 2025-03-05 14:03:53 01380_coded_delta_exception_code: [ OK ] 0.93 sec. 2025-03-05 14:03:53 01378_alter_rename_with_ttl_zookeeper: [ OK ] 0.96 sec. 2025-03-05 14:03:54 01358_constexpr_constraint: [ OK ] 0.45 sec. 2025-03-05 14:03:54 01375_storage_file_write_prefix_tsv_with_names: [ OK ] 0.72 sec. 2025-03-05 14:03:54 01351_parse_date_time_best_effort_us: [ OK ] 0.47 sec. 2025-03-05 14:03:54 01377_supertype_low_cardinality: [ OK ] 1.36 sec. 2025-03-05 14:03:54 01349_mutation_datetime_key: [ OK ] 0.69 sec. 2025-03-05 14:03:54 01347_partition_date_vs_datetime: [ OK ] 0.53 sec. 2025-03-05 14:03:55 01338_sha256_fixedstring: [ OK ] 0.56 sec. 2025-03-05 14:03:55 01330_array_join_in_higher_order_function: [ OK ] 0.46 sec. 2025-03-05 14:03:55 01324_settings_documentation: [ OK ] 0.46 sec. 2025-03-05 14:03:55 01332_join_type_syntax_position: [ OK ] 1.02 sec. 2025-03-05 14:03:56 01340_datetime64_fpe: [ OK ] 1.69 sec. 2025-03-05 14:03:56 01322_cast_keep_nullable: [ OK ] 0.59 sec. 2025-03-05 14:03:56 01321_monotonous_functions_in_order_by_bug: [ OK ] 0.46 sec. 2025-03-05 14:03:56 01319_mv_constants_bug: [ OK ] 0.54 sec. 2025-03-05 14:03:56 01323_redundant_functions_in_order_by: [ OK ] 1.53 sec. 2025-03-05 14:03:56 01318_alter_add_column_exists: [ OK ] 0.56 sec. 2025-03-05 14:03:57 01314_position_in_system_columns: [ OK ] 0.44 sec. 2025-03-05 14:03:57 01310_enum_comparison: [ OK ] 0.62 sec. 2025-03-05 14:03:57 01308_row_policy_and_trivial_count_query: [ OK ] 0.54 sec. 2025-03-05 14:03:57 01307_polygon_perimeter: [ OK ] 0.40 sec. 2025-03-05 14:03:58 01305_nullable-prewhere_bug: [ OK ] 0.86 sec. 2025-03-05 14:03:59 01318_map_add_map_subtract: [ OK ] 2.37 sec. 2025-03-05 14:03:59 01299_alter_merge_tree: [ OK ] 0.71 sec. 2025-03-05 14:04:00 01297_alter_distributed: [ OK ] 0.79 sec. 2025-03-05 14:04:00 01292_quantile_array_bug: [ OK ] 0.48 sec. 2025-03-05 14:04:01 01292_optimize_data_skip_idx_order_by_expr: [ OK ] 0.52 sec. 2025-03-05 14:04:01 01291_geo_types: [ OK ] 0.45 sec. 2025-03-05 14:04:02 01293_external_sorting_limit_bug: [ OK ] 2.62 sec. 2025-03-05 14:04:02 01319_query_formatting_in_server_log: [ OK ] 6.43 sec. 2025-03-05 14:04:02 01290_empty_array_index_analysis: [ OK ] 1.30 sec. 2025-03-05 14:04:03 01285_data_skip_index_over_aggregation: [ OK ] 0.86 sec. 2025-03-05 14:04:03 01280_null_in: [ OK ] 0.66 sec. 2025-03-05 14:04:04 01278_alter_rename_combination: [ OK ] 0.93 sec. 2025-03-05 14:04:04 01281_alter_rename_and_other_renames: [ OK ] 1.64 sec. 2025-03-05 14:04:05 01277_alter_rename_column_constraint: [ OK ] 1.55 sec. 2025-03-05 14:04:06 01277_alter_rename_column_constraint_zookeeper_long: [ OK ] 2.44 sec. 2025-03-05 14:04:07 01275_alter_rename_column_default_expr: [ OK ] 1.37 sec. 2025-03-05 14:04:08 01271_show_privileges: [ OK ] 0.49 sec. 2025-03-05 14:04:14 01655_plan_optimizations_optimize_read_in_window_order_long: [ OK ] 93.17 sec. 2025-03-05 14:04:16 01269_toStartOfSecond: [ OK ] 1.10 sec. 2025-03-05 14:04:16 01260_ubsan_decimal_parse: [ OK ] 0.43 sec. 2025-03-05 14:04:17 01271_optimize_arithmetic_operations_in_aggr_func_long: [ OK ] 8.94 sec. 2025-03-05 14:04:17 01259_combinator_distinct: [ OK ] 0.97 sec. 2025-03-05 14:04:18 01248_least_greatest_mixed_const: [ OK ] 0.45 sec. 2025-03-05 14:04:18 01240_join_get_or_null: [ OK ] 0.79 sec. 2025-03-05 14:04:19 01232_untuple: [ OK ] 0.74 sec. 2025-03-05 14:04:24 01626_cnf_fuzz_long: [ OK ] 89.85 sec. 2025-03-05 14:04:24 01252_weird_time_zone: [ OK ] 7.39 sec. 2025-03-05 14:04:25 01226_dist_on_dist_global_in: [ OK ] 0.90 sec. 2025-03-05 14:04:25 01213_optimize_skip_unused_shards_DISTINCT: [ OK ] 0.97 sec. 2025-03-05 14:04:27 01213_alter_rename_with_default_zookeeper_long: [ OK ] 1.39 sec. 2025-03-05 14:04:28 01213_alter_rename_nested: [ OK ] 1.32 sec. 2025-03-05 14:04:28 01210_drop_view: [ OK ] 0.51 sec. 2025-03-05 14:04:30 01202_array_auc_special: [ OK ] 1.24 sec. 2025-03-05 14:04:32 01213_alter_rename_column_zookeeper_long: [ OK ] 6.76 sec. 2025-03-05 14:04:33 01231_operator_null_in: [ OK ] 13.35 sec. 2025-03-05 14:04:45 01182_materialized_view_different_structure: [ OK ] 12.25 sec. 2025-03-05 14:04:47 01181_db_atomic_drop_on_cluster: [ OK ] 1.83 sec. 2025-03-05 14:04:49 01179_insert_values_semicolon: [ OK ] 1.83 sec. 2025-03-05 14:04:56 01161_information_schema: [ OK ] 6.97 sec. 2025-03-05 14:05:13 01156_pcg_deserialization: [ OK ] 16.96 sec. 2025-03-05 14:05:14 01151_storage_merge_filter_tables_by_virtual_column: [ OK ] 1.36 sec. 2025-03-05 14:05:17 01146_clickhouse_local_data: [ OK ] 2.36 sec. 2025-03-05 14:05:18 01142_with_ties_and_aliases: [ OK ] 0.88 sec. 2025-03-05 14:05:20 01135_default_and_alter_zookeeper: [ OK ] 2.10 sec. 2025-03-05 14:05:27 01128_generate_random_nested: [ OK ] 7.24 sec. 2025-03-05 14:05:28 01126_month_partitioning_consistent_code: [ OK ] 0.52 sec. 2025-03-05 14:05:28 01117_greatest_least_case: [ OK ] 0.42 sec. 2025-03-05 14:05:29 01114_clear_column_compact_parts: [ OK ] 0.71 sec. 2025-03-05 14:05:30 01106_const_fixed_string_like: [ OK ] 1.01 sec. 2025-03-05 14:05:31 01184_long_insert_values_huge_strings: [ OK ] 58.72 sec. 2025-03-05 14:05:31 01105_string_like: [ OK ] 1.30 sec. 2025-03-05 14:05:32 01102_distributed_local_in_bug: [ OK ] 0.77 sec. 2025-03-05 14:05:32 01096_array_reduce_in_ranges: [ OK ] 0.51 sec. 2025-03-05 14:05:34 01087_table_function_generate: [ OK ] 1.46 sec. 2025-03-05 14:05:34 01099_operators_date_and_timestamp: [ OK ] 2.36 sec. 2025-03-05 14:05:34 01083_match_zero_byte: [ OK ] 0.62 sec. 2025-03-05 14:05:35 01081_keywords_formatting: [ OK ] 0.40 sec. 2025-03-05 14:05:36 01080_engine_merge_prewhere_tupleelement_error: [ OK ] 0.68 sec. 2025-03-05 14:05:36 01277_random_fixed_string: [ OK ] 93.22 sec. 2025-03-05 14:05:36 01201_read_single_thread_in_order: [ OK ] 66.74 sec. 2025-03-05 14:05:37 01080_check_for_error_incorrect_size_of_nested_column: [ OK ] 0.81 sec. 2025-03-05 14:05:37 01086_regexp_input_format_skip_unmatched: [ OK ] 2.83 sec. 2025-03-05 14:05:37 01074_h3_range_check: [ OK ] 0.69 sec. 2025-03-05 14:05:42 01276_random_string: [ OK ] 96.62 sec. 2025-03-05 14:05:42 01072_json_each_row_data_in_square_brackets: [ OK ] 0.47 sec. 2025-03-05 14:05:43 01076_window_view_alter_query_to: [ OK ] 6.52 sec. 2025-03-05 14:05:43 01073_blockSerializedSize: [ OK ] 5.88 sec. 2025-03-05 14:05:43 01077_mutations_index_consistency: [ OK ] 6.87 sec. 2025-03-05 14:05:44 01071_force_optimize_skip_unused_shards: [ OK ] 1.41 sec. 2025-03-05 14:05:44 01065_if_not_finite: [ OK ] 0.70 sec. 2025-03-05 14:05:44 01063_create_column_set: [ OK ] 0.50 sec. 2025-03-05 14:05:45 01062_pm_multiple_all_join_same_value: [ OK ] 0.76 sec. 2025-03-05 14:05:46 01079_bad_alters_zookeeper_long: [ OK ] 9.55 sec. 2025-03-05 14:05:47 01062_alter_on_mutataion_zookeeper_long: [ OK ] 2.98 sec. 2025-03-05 14:05:47 01066_window_view_event_tumble_to_strict_asc_lateness: [ OK ] 4.35 sec. 2025-03-05 14:05:48 01063_window_view_event_tumble_to_bounded: [ OK ] 4.37 sec. 2025-03-05 14:05:50 01058_window_view_event_hop_to_strict_asc: [ OK ] 3.96 sec. 2025-03-05 14:05:51 01053_if_chain_check: [ OK ] 1.15 sec. 2025-03-05 14:05:51 01057_http_compression_prefer_brotli: [ OK ] 3.70 sec. 2025-03-05 14:05:52 01051_random_printable_ascii: [ OK ] 0.46 sec. 2025-03-05 14:05:52 01050_engine_join_view_crash: [ OK ] 0.80 sec. 2025-03-05 14:05:53 01055_compact_parts_granularity: [ OK ] 5.03 sec. 2025-03-05 14:05:53 01049_join_low_card_crash: [ OK ] 0.93 sec. 2025-03-05 14:05:53 01058_zlib_ng_level1_bug: [ OK ] 8.13 sec. 2025-03-05 14:05:54 01046_materialized_view_with_join_over_distributed: [ OK ] 1.17 sec. 2025-03-05 14:05:54 01047_simple_aggregate_sizes_of_columns_bug: [ OK ] 1.57 sec. 2025-03-05 14:05:54 02231_buffer_aggregate_states_leak: [ OK ] 284.59 sec. 2025-03-05 14:05:55 01041_create_dictionary_if_not_exists: [ OK ] 0.67 sec. 2025-03-05 14:05:55 01047_window_view_parser_inner_table: [ OK ] 2.22 sec. 2025-03-05 14:05:55 01036_union_different_columns: [ OK ] 0.42 sec. 2025-03-05 14:05:55 01039_test_setting_parse: [ OK ] 0.76 sec. 2025-03-05 14:05:56 01039_row_policy_dcl: [ OK ] 1.56 sec. 2025-03-05 14:05:56 01030_storage_hdfs_syntax: [ OK ] 0.53 sec. 2025-03-05 14:05:56 01032_cityHash64_for_UUID: [ OK ] 0.67 sec. 2025-03-05 14:05:56 01029_early_constant_folding: [ OK ] 0.44 sec. 2025-03-05 14:05:57 01020_function_array_compact: [ OK ] 0.57 sec. 2025-03-05 14:05:57 01021_only_tuple_columns: [ OK ] 1.46 sec. 2025-03-05 14:05:58 01020_function_char: [ OK ] 0.58 sec. 2025-03-05 14:05:58 01030_limit_by_with_ties_error: [ OK ] 2.41 sec. 2025-03-05 14:05:59 01018_ambiguous_column: [ OK ] 0.63 sec. 2025-03-05 14:06:01 01035_enum_conversion_native_format: [ OK ] 5.84 sec. 2025-03-05 14:06:01 01054_cache_dictionary_bunch_update: [ OK ] 13.38 sec. 2025-03-05 14:06:02 01012_show_tables_limit: [ OK ] 0.62 sec. 2025-03-05 14:06:03 01019_alter_materialized_view_consistent: [ OK ] 5.68 sec. 2025-03-05 14:06:03 01015_empty_in_inner_right_join: [ OK ] 2.42 sec. 2025-03-05 14:06:04 01012_select_limit_x_0: [ OK ] 0.42 sec. 2025-03-05 14:06:04 01011_test_create_as_skip_indices: [ OK ] 0.57 sec. 2025-03-05 14:06:05 01010_partial_merge_join_const_and_lc: [ OK ] 1.39 sec. 2025-03-05 14:06:05 01010_partial_merge_join_negative: [ OK ] 1.57 sec. 2025-03-05 14:06:05 01017_mutations_with_nondeterministic_functions_zookeeper: [ OK ] 6.60 sec. 2025-03-05 14:06:06 01009_global_array_join_names: [ OK ] 0.56 sec. 2025-03-05 14:06:07 01009_insert_select_data_loss: [ OK ] 1.11 sec. 2025-03-05 14:06:07 01001_enums_in_in_section: [ OK ] 0.75 sec. 2025-03-05 14:06:08 01008_materialized_view_henyihanwobushi: [ OK ] 2.64 sec. 2025-03-05 14:06:09 01012_serialize_array_memory_usage: [ OK ] 6.84 sec. 2025-03-05 14:06:09 01006_ttl_with_default_2: [ OK ] 3.38 sec. 2025-03-05 14:06:10 00999_test_skip_indices_with_alter_and_merge: [ OK ] 2.44 sec. 2025-03-05 14:06:11 00999_join_not_nullable_types: [ OK ] 1.64 sec. 2025-03-05 14:06:11 00988_expansion_aliases_limit: [ OK ] 0.67 sec. 2025-03-05 14:06:12 00999_join_on_expression: [ OK ] 3.54 sec. 2025-03-05 14:06:22 00995_exception_while_insert: [ OK ] 11.52 sec. 2025-03-05 14:06:24 00980_alter_settings_race: [ OK ] 11.86 sec. 2025-03-05 14:06:24 00979_set_index_not: [ OK ] 1.61 sec. 2025-03-05 14:06:24 00986_materialized_view_stack_overflow: [ OK ] 12.76 sec. 2025-03-05 14:06:24 00978_ml_math: [ OK ] 0.61 sec. 2025-03-05 14:06:26 00977_int_div: [ OK ] 1.74 sec. 2025-03-05 14:06:29 00971_merge_tree_uniform_read_distribution_and_max_rows_to_read: [ OK ] 3.13 sec. 2025-03-05 14:06:30 00969_roundDuration: [ OK ] 0.96 sec. 2025-03-05 14:06:46 00974_adaptive_granularity_secondary_index: [ OK ] 22.32 sec. 2025-03-05 14:06:57 00997_trim: [ OK ] 47.14 sec. 2025-03-05 14:06:57 01019_alter_materialized_view_atomic: [ OK ] 59.27 sec. 2025-03-05 14:06:57 00964_os_thread_priority: [ OK ] 0.43 sec. 2025-03-05 14:06:57 01304_direct_io_long: [ OK ] 179.70 sec. 2025-03-05 14:06:57 00961_checksums_in_system_parts_columns_table: [ OK ] 0.42 sec. 2025-03-05 14:06:58 00957_coalesce_const_nullable_crash: [ OK ] 0.59 sec. 2025-03-05 14:06:58 00972_geohashesInBox: [ OK ] 33.64 sec. 2025-03-05 14:06:59 00956_http_prepared_statements: [ OK ] 1.43 sec. 2025-03-05 14:06:59 00950_default_prewhere: [ OK ] 0.82 sec. 2025-03-05 14:07:00 00952_insert_into_distributed_with_materialized_column: [ OK ] 1.82 sec. 2025-03-05 14:07:00 00945_ml_test: [ OK ] 0.57 sec. 2025-03-05 14:07:00 00948_values_interpreter_template: [ OK ] 0.83 sec. 2025-03-05 14:07:01 00942_mv_rename_table: [ OK ] 0.69 sec. 2025-03-05 14:07:01 01049_join_low_card_bug_long: [ OK ] 69.20 sec. 2025-03-05 14:07:01 00955_test_final_mark_use: [ OK ] 4.14 sec. 2025-03-05 14:07:02 00940_max_parts_in_total: [ OK ] 0.90 sec. 2025-03-05 14:07:03 00940_order_by_read_in_order: [ OK ] 1.58 sec. 2025-03-05 14:07:03 00938_ipv6_cidr_range: [ OK ] 1.38 sec. 2025-03-05 14:07:03 00964_bloom_index_string_functions: [ OK ] 16.50 sec. 2025-03-05 14:07:04 00951_ngram_search: [ OK ] 6.17 sec. 2025-03-05 14:07:06 00937_template_output_format: [ OK ] 3.08 sec. 2025-03-05 14:07:07 00937_format_schema_rows_template: [ OK ] 4.26 sec. 2025-03-05 14:07:08 00931_low_cardinality_set_index_in_key_condition: [ OK ] 0.49 sec. 2025-03-05 14:07:08 00944_create_bloom_filter_index_with_merge_tree: [ OK ] 7.98 sec. 2025-03-05 14:07:08 00931_low_cardinality_read_with_empty_array: [ OK ] 2.35 sec. 2025-03-05 14:07:09 00930_arrayIntersect: [ OK ] 0.98 sec. 2025-03-05 14:07:09 00919_histogram_merge: [ OK ] 0.66 sec. 2025-03-05 14:07:09 00937_test_use_header_csv: [ OK ] 7.25 sec. 2025-03-05 14:07:10 00917_least_sqr: [ OK ] 0.54 sec. 2025-03-05 14:07:11 00933_ttl_replicated_zookeeper: [ OK ] 6.29 sec. 2025-03-05 14:07:11 00906_low_cardinality_const_argument: [ OK ] 0.41 sec. 2025-03-05 14:07:12 00905_field_with_aggregate_function_state: [ OK ] 0.63 sec. 2025-03-05 14:07:12 00903_array_with_constant_function: [ OK ] 0.40 sec. 2025-03-05 14:07:13 00902_entropy: [ OK ] 0.76 sec. 2025-03-05 14:07:14 00918_json_functions: [ OK ] 5.11 sec. 2025-03-05 14:07:17 00900_orc_nested_arrays_load: [ OK ] 3.56 sec. 2025-03-05 14:07:17 00900_entropy_shard: [ OK ] 0.52 sec. 2025-03-05 14:07:19 00910_zookeeper_custom_compression_codecs_replicated_long: [ OK ] 9.95 sec. 2025-03-05 14:07:20 00875_join_right_nulls: [ OK ] 2.79 sec. 2025-03-05 14:07:21 00861_decimal_quoted_csv: [ OK ] 0.50 sec. 2025-03-05 14:07:21 00900_orc_arrow_parquet_maps: [ OK ] 7.32 sec. 2025-03-05 14:07:21 00860_unknown_identifier_bug: [ OK ] 0.50 sec. 2025-03-05 14:07:22 00856_no_column_issue_4242: [ OK ] 0.66 sec. 2025-03-05 14:07:22 00852_any_join_nulls: [ OK ] 0.78 sec. 2025-03-05 14:07:23 00843_optimize_predicate_and_rename_table: [ OK ] 0.89 sec. 2025-03-05 14:07:23 00842_array_with_constant_overflow: [ OK ] 0.43 sec. 2025-03-05 14:07:24 00850_global_join_dups: [ OK ] 1.97 sec. 2025-03-05 14:07:24 00841_temporary_table_database: [ OK ] 0.47 sec. 2025-03-05 14:07:24 00870_t64_codec: [ OK ] 4.85 sec. 2025-03-05 14:07:25 00832_storage_file_lock: [ OK ] 0.58 sec. 2025-03-05 14:07:25 00834_limit_with_constant_expressions: [ OK ] 1.17 sec. 2025-03-05 14:07:25 00836_indices_alter: [ OK ] 1.27 sec. 2025-03-05 14:07:26 00829_bitmap64_function: [ OK ] 1.36 sec. 2025-03-05 14:07:27 00927_asof_join_long: [ OK ] 18.67 sec. 2025-03-05 14:07:28 00825_protobuf_format_array_of_arrays: [ OK ] 2.97 sec. 2025-03-05 14:07:29 00825_protobuf_format_no_length_delimiter: [ OK ] 3.69 sec. 2025-03-05 14:07:29 00802_system_parts_with_datetime_partition: [ OK ] 1.18 sec. 2025-03-05 14:07:29 00804_test_custom_compression_codes_log_storages: [ OK ] 2.53 sec. 2025-03-05 14:07:30 00825_protobuf_format_squares: [ OK ] 3.18 sec. 2025-03-05 14:07:30 00762_date_comparsion: [ OK ] 0.91 sec. 2025-03-05 14:07:30 00936_substring_utf8_non_const: [ OK ] 26.69 sec. 2025-03-05 14:07:30 00758_array_reverse: [ OK ] 0.76 sec. 2025-03-05 14:07:30 00757_enum_defaults_const_analyzer: [ OK ] 0.52 sec. 2025-03-05 14:07:31 00749_inner_join_of_unnamed_subqueries: [ OK ] 0.69 sec. 2025-03-05 14:07:31 00965_shard_unresolvable_addresses: [ OK ] 60.85 sec. 2025-03-05 14:07:31 00740_database_in_nested_view: [ OK ] 0.79 sec. 2025-03-05 14:07:31 00753_alter_destination_for_storage_buffer: [ OK ] 1.08 sec. 2025-03-05 14:07:31 00738_nested_merge_multidimensional_array: [ OK ] 0.78 sec. 2025-03-05 14:07:32 00732_quorum_insert_select_with_old_data_and_without_quorum_zookeeper_long: [ OK ] 1.05 sec. 2025-03-05 14:07:32 00732_quorum_insert_lost_part_zookeeper_long: [ OK ] 1.20 sec. 2025-03-05 14:07:32 00908_bloom_filter_index: [ OK ] 22.42 sec. 2025-03-05 14:07:32 00732_quorum_insert_lost_part_and_alive_part_zookeeper_long: [ OK ] 1.54 sec. 2025-03-05 14:07:32 00726_length_aliases: [ OK ] 0.44 sec. 2025-03-05 14:07:33 00754_alter_modify_column_partitions: [ OK ] 2.80 sec. 2025-03-05 14:07:33 00725_comment_columns_long: [ OK ] 0.82 sec. 2025-03-05 14:07:33 00713_collapsing_merge_tree: [ OK ] 0.58 sec. 2025-03-05 14:07:34 00712_prewhere_with_missing_columns: [ OK ] 0.78 sec. 2025-03-05 14:07:34 00729_prewhere_array_join: [ OK ] 2.32 sec. 2025-03-05 14:07:34 00717_low_cardinaliry_group_by: [ OK ] 1.66 sec. 2025-03-05 14:07:34 00712_prewhere_with_alias: [ OK ] 1.06 sec. 2025-03-05 14:07:34 00709_virtual_column_partition_id: [ OK ] 0.48 sec. 2025-03-05 14:07:35 00712_nan_comparison: [ OK ] 1.06 sec. 2025-03-05 14:07:35 00702_join_with_using: [ OK ] 0.82 sec. 2025-03-05 14:07:37 00704_drop_truncate_memory_table: [ OK ] 2.45 sec. 2025-03-05 14:07:37 00700_decimal_round: [ OK ] 2.12 sec. 2025-03-05 14:07:38 00700_decimal_math: [ OK ] 1.05 sec. 2025-03-05 14:07:39 00700_decimal_casts: [ OK ] 3.78 sec. 2025-03-05 14:07:39 00700_decimal_in_keys: [ OK ] 1.89 sec. 2025-03-05 14:07:40 00698_validate_array_sizes_for_nested: [ OK ] 0.91 sec. 2025-03-05 14:07:40 00717_low_cardinaliry_distributed_group_by: [ OK ] 7.39 sec. 2025-03-05 14:07:40 00689_join_table_function: [ OK ] 0.41 sec. 2025-03-05 14:07:40 00696_system_columns_limit: [ OK ] 0.71 sec. 2025-03-05 14:07:41 00688_case_without_else: [ OK ] 0.42 sec. 2025-03-05 14:07:41 00697_in_subquery_shard: [ OK ] 1.77 sec. 2025-03-05 14:07:41 00754_distributed_optimize_skip_select_on_unused_shards: [ OK ] 11.81 sec. 2025-03-05 14:07:42 00699_materialized_view_mutations: [ OK ] 3.88 sec. 2025-03-05 14:07:42 00674_has_array_enum: [ OK ] 0.42 sec. 2025-03-05 14:07:42 00688_low_cardinality_syntax: [ OK ] 1.78 sec. 2025-03-05 14:07:42 00728_json_each_row_parsing: [ OK ] 10.17 sec. 2025-03-05 14:07:42 00668_compare_arrays_silviucpp: [ OK ] 0.44 sec. 2025-03-05 14:07:43 00678_shard_funnel_window: [ OK ] 1.46 sec. 2025-03-05 14:07:43 00647_select_numbers_with_offset: [ OK ] 0.41 sec. 2025-03-05 14:07:43 00645_date_time_input_format: [ OK ] 0.39 sec. 2025-03-05 14:07:43 00646_weird_mmx: [ OK ] 0.46 sec. 2025-03-05 14:07:43 00666_uniq_complex_types: [ OK ] 1.37 sec. 2025-03-05 14:07:44 00626_in_syntax: [ OK ] 0.99 sec. 2025-03-05 14:07:45 00625_arrays_in_nested: [ OK ] 1.29 sec. 2025-03-05 14:07:55 00652_mergetree_mutations: [ OK ] 12.81 sec. 2025-03-05 14:07:56 00619_extract: [ OK ] 0.89 sec. 2025-03-05 14:07:57 00617_array_in: [ OK ] 0.69 sec. 2025-03-05 14:07:57 00625_summing_merge_tree_merge: [ OK ] 11.29 sec. 2025-03-05 14:07:57 00612_http_max_query_size_for_distributed: [ OK ] 0.71 sec. 2025-03-05 14:07:58 00608_uniq_array: [ OK ] 0.70 sec. 2025-03-05 14:07:58 00593_union_all_assert_columns_removed: [ OK ] 0.54 sec. 2025-03-05 14:07:59 00592_union_all_different_aliases: [ OK ] 0.45 sec. 2025-03-05 14:07:59 00591_columns_removal_union_all: [ OK ] 0.50 sec. 2025-03-05 14:08:00 00586_removing_unused_columns_from_subquery: [ OK ] 0.96 sec. 2025-03-05 14:08:01 00578_merge_table_shadow_virtual_column: [ OK ] 0.85 sec. 2025-03-05 14:08:02 00568_empty_function_with_fixed_string: [ OK ] 0.57 sec. 2025-03-05 14:08:02 00563_complex_in_expression: [ OK ] 0.61 sec. 2025-03-05 14:08:03 00559_filter_array_generic: [ OK ] 0.40 sec. 2025-03-05 14:08:03 00682_empty_parts_merge: [ OK ] 22.17 sec. 2025-03-05 14:08:03 00551_parse_or_null: [ OK ] 0.45 sec. 2025-03-05 14:08:04 00547_named_tuples: [ OK ] 0.54 sec. 2025-03-05 14:08:04 00602_throw_if: [ OK ] 7.01 sec. 2025-03-05 14:08:05 00546_shard_tuple_element_formatting: [ OK ] 0.51 sec. 2025-03-05 14:08:05 00543_null_and_prewhere: [ OK ] 0.54 sec. 2025-03-05 14:08:05 00534_functions_bad_arguments2: [ SKIPPED ] 0.00 sec. - not running for current build 2025-03-05 14:08:05 00534_functions_bad_arguments12: [ SKIPPED ] 0.00 sec. - not running for current build 2025-03-05 14:08:05 00534_functions_bad_arguments11: [ SKIPPED ] 0.00 sec. - not running for current build 2025-03-05 14:08:05 00554_nested_and_table_engines: [ OK ] 2.31 sec. 2025-03-05 14:08:06 00539_functions_for_working_with_json: [ OK ] 0.79 sec. 2025-03-05 14:08:06 00532_topk_generic: [ OK ] 0.50 sec. 2025-03-05 14:08:06 00531_aggregate_over_nullable: [ OK ] 0.73 sec. 2025-03-05 14:08:06 00705_drop_create_merge_tree: [ OK ] 31.98 sec. 2025-03-05 14:08:06 00530_arrays_of_nothing: [ OK ] 0.61 sec. 2025-03-05 14:08:07 00525_aggregate_functions_of_nullable_that_return_non_nullable: [ OK ] 0.64 sec. 2025-03-05 14:08:07 00523_aggregate_functions_in_group_array: [ OK ] 0.48 sec. 2025-03-05 14:08:07 00520_tuple_values_interpreter: [ OK ] 0.55 sec. 2025-03-05 14:08:07 00632_get_sample_block_cache: [ OK ] 23.73 sec. 2025-03-05 14:08:08 00515_shard_desc_table_functions_and_subqueries: [ OK ] 0.77 sec. 2025-03-05 14:08:08 00531_client_ignore_error: [ OK ] 2.24 sec. 2025-03-05 14:08:09 00507_array_no_params: [ OK ] 2.38 sec. 2025-03-05 14:08:09 00504_mergetree_arrays_rw: [ OK ] 1.73 sec. 2025-03-05 14:08:09 00502_sum_map: [ OK ] 1.47 sec. 2025-03-05 14:08:09 00517_date_parsing: [ OK ] 2.82 sec. 2025-03-05 14:08:10 00505_secure: [ OK ] 2.86 sec. 2025-03-05 14:08:10 00498_bitwise_aggregate_functions: [ OK ] 0.54 sec. 2025-03-05 14:08:10 00490_with_select: [ OK ] 0.55 sec. 2025-03-05 14:08:11 00501_http_head: [ OK ] 1.40 sec. 2025-03-05 14:08:11 00488_non_ascii_column_names: [ OK ] 0.53 sec. 2025-03-05 14:08:12 00486_if_fixed_string: [ OK ] 0.86 sec. 2025-03-05 14:08:12 00482_subqueries_and_aliases: [ OK ] 0.66 sec. 2025-03-05 14:08:12 00481_create_view_for_null: [ OK ] 0.45 sec. 2025-03-05 14:08:12 00500_point_in_polygon_non_const_poly: [ OK ] 2.87 sec. 2025-03-05 14:08:12 00476_pretty_formats_and_widths: [ OK ] 0.48 sec. 2025-03-05 14:08:13 00470_identifiers_in_double_quotes: [ OK ] 0.39 sec. 2025-03-05 14:08:13 00464_array_element_out_of_range: [ OK ] 0.43 sec. 2025-03-05 14:08:13 00445_join_nullable_keys: [ OK ] 0.78 sec. 2025-03-05 14:08:14 00447_foreach_modifier: [ OK ] 1.25 sec. 2025-03-05 14:08:14 00439_fixed_string_filter: [ OK ] 0.44 sec. 2025-03-05 14:08:14 00458_merge_type_cast: [ OK ] 1.87 sec. 2025-03-05 14:08:14 00436_convert_charset: [ OK ] 0.49 sec. 2025-03-05 14:08:15 00436_fixed_string_16_comparisons: [ OK ] 1.07 sec. 2025-03-05 14:08:15 00430_https_server: [ OK ] 1.14 sec. 2025-03-05 14:08:15 00424_shard_aggregate_functions_of_nullable: [ OK ] 0.89 sec. 2025-03-05 14:08:16 00497_whitespaces_in_insert: [ OK ] 5.93 sec. 2025-03-05 14:08:19 00498_array_functions_concat_slice_push_pop: [ OK ] 9.09 sec. 2025-03-05 14:08:19 00419_show_sql_queries: [ OK ] 3.76 sec. 2025-03-05 14:08:19 00403_to_start_of_day: [ OK ] 0.35 sec. 2025-03-05 14:08:20 00399_group_uniq_array_date_datetime: [ OK ] 0.76 sec. 2025-03-05 14:08:20 00409_shard_limit_by: [ OK ] 1.55 sec. 2025-03-05 14:08:21 00397_tsv_format_synonym: [ OK ] 0.50 sec. 2025-03-05 14:08:21 00394_new_nested_column_keeps_offsets: [ OK ] 0.73 sec. 2025-03-05 14:08:21 00378_json_quote_64bit_integers: [ OK ] 0.74 sec. 2025-03-05 14:08:26 00626_replace_partition_from_table_zookeeper: [ OK ] 42.99 sec. 2025-03-05 14:08:27 00373_group_by_tuple: [ OK ] 0.50 sec. 2025-03-05 14:08:28 00364_java_style_denormals: [ OK ] 0.51 sec. 2025-03-05 14:08:30 00354_host_command_line_option: [ OK ] 2.50 sec. 2025-03-05 14:08:31 00348_tuples: [ OK ] 0.91 sec. 2025-03-05 14:08:32 00347_has_tuple: [ OK ] 0.92 sec. 2025-03-05 14:08:32 00411_long_accurate_number_comparison_float: [ OK ] 17.10 sec. 2025-03-05 14:08:33 00338_replicate_array_of_strings: [ OK ] 0.62 sec. 2025-03-05 14:08:33 00339_parsing_bad_arrays: [ OK ] 1.27 sec. 2025-03-05 14:08:34 00334_column_aggregate_function_limit: [ OK ] 0.60 sec. 2025-03-05 14:08:34 00333_parser_number_bug: [ OK ] 0.36 sec. 2025-03-05 14:08:37 00411_long_accurate_number_comparison_int4: [ OK ] 21.24 sec. 2025-03-05 14:08:38 00336_shard_stack_trace: [ OK ] 4.30 sec. 2025-03-05 14:08:39 00322_disable_checksumming: [ OK ] 2.06 sec. 2025-03-05 14:08:39 00307_format_xml: [ OK ] 0.41 sec. 2025-03-05 14:08:39 00375_shard_group_uniq_array_of_string: [ OK ] 18.04 sec. 2025-03-05 14:08:40 00300_csv: [ OK ] 0.51 sec. 2025-03-05 14:08:40 00291_array_reduce: [ OK ] 0.44 sec. 2025-03-05 14:08:40 00296_url_parameters: [ OK ] 0.88 sec. 2025-03-05 14:08:44 00282_merging: [ OK ] 3.18 sec. 2025-03-05 14:08:44 00268_aliases_without_as_keyword: [ OK ] 0.45 sec. 2025-03-05 14:08:45 00267_tuple_array_access_operators_priority: [ OK ] 0.45 sec. 2025-03-05 14:08:45 00323_quantiles_timing_bug: [ OK ] 10.50 sec. 2025-03-05 14:08:45 00258_materializing_tuples: [ OK ] 0.56 sec. 2025-03-05 14:08:45 00290_shard_aggregation_memory_efficient: [ OK ] 5.01 sec. 2025-03-05 14:08:47 00257_shard_no_aggregates_and_constant_keys: [ OK ] 1.62 sec. 2025-03-05 14:08:47 00236_replicated_drop_on_non_leader_zookeeper_long: [ OK ] 1.24 sec. 2025-03-05 14:08:47 00234_disjunctive_equality_chains_optimization: [ OK ] 0.49 sec. 2025-03-05 14:08:48 00225_join_duplicate_columns: [ OK ] 0.58 sec. 2025-03-05 14:08:48 00230_array_functions_has_count_equal_index_of_non_const_second_arg: [ OK ] 1.11 sec. 2025-03-05 14:08:48 00220_shard_with_totals_in_subquery_remote_and_limit: [ OK ] 0.64 sec. 2025-03-05 14:08:49 00240_replace_substring_loop: [ OK ] 3.54 sec. 2025-03-05 14:08:49 00219_full_right_join_column_order: [ OK ] 0.95 sec. 2025-03-05 14:08:50 00214_primary_key_order: [ OK ] 0.66 sec. 2025-03-05 14:08:50 00200_shard_distinct_order_by_limit_distributed: [ OK ] 0.72 sec. 2025-03-05 14:08:52 00205_scalar_subqueries: [ OK ] 2.37 sec. 2025-03-05 14:08:52 00199_ternary_operator_type_check: [ OK ] 1.86 sec. 2025-03-05 14:08:52 00197_if_fixed_string: [ OK ] 0.62 sec. 2025-03-05 14:08:53 00196_float32_formatting: [ OK ] 0.58 sec. 2025-03-05 14:08:53 00224_shard_distributed_aggregation_memory_efficient_and_overflows: [ OK ] 5.30 sec. 2025-03-05 14:08:53 00191_aggregating_merge_tree_and_final: [ OK ] 0.80 sec. 2025-03-05 14:08:54 00157_aliases_and_lambda_formal_parameters: [ OK ] 0.38 sec. 2025-03-05 14:08:54 00167_settings_inside_query: [ OK ] 0.86 sec. 2025-03-05 14:08:54 00152_totals_in_subquery: [ OK ] 0.46 sec. 2025-03-05 14:08:55 00151_tuple_with_array: [ OK ] 0.42 sec. 2025-03-05 14:08:56 00146_summing_merge_tree_nested_map: [ OK ] 1.07 sec. 2025-03-05 14:08:57 00145_empty_likes: [ OK ] 0.65 sec. 2025-03-05 14:08:57 00140_prewhere_column_order: [ OK ] 0.54 sec. 2025-03-05 14:08:59 00121_drop_column_zookeeper: [ OK ] 1.36 sec. 2025-03-05 14:09:00 00119_storage_join: [ OK ] 0.82 sec. 2025-03-05 14:09:22 00673_subquery_prepared_set_performance: [ OK ] 100.16 sec. 2025-03-05 14:09:22 00114_float_type_result_of_division: [ OK ] 0.46 sec. 2025-03-05 14:09:23 00098_d_union_all: [ OK ] 0.58 sec. 2025-03-05 14:09:24 00098_6_union_all: [ OK ] 0.43 sec. 2025-03-05 14:09:24 00098_3_union_all: [ OK ] 0.63 sec. 2025-03-05 14:09:27 00115_shard_in_incomplete_result: [ OK ] 27.74 sec. 2025-03-05 14:09:28 00089_group_by_arrays_of_fixed: [ OK ] 0.55 sec. 2025-03-05 14:09:28 00087_distinct_of_empty_arrays: [ OK ] 0.46 sec. 2025-03-05 14:09:35 00086_concat_nary_const_with_nonconst_segfault: [ OK ] 6.34 sec. 2025-03-05 14:09:35 00077_set_keys_fit_128_bits_many_blocks: [ OK ] 0.50 sec. 2025-03-05 14:09:37 00063_check_query: [ OK ] 1.40 sec. 2025-03-05 14:09:37 00056_join_number_string: [ OK ] 0.51 sec. 2025-03-05 14:09:39 00048_b_stored_aggregates_merge: [ OK ] 1.55 sec. 2025-03-05 14:09:39 00044_sorting_by_string_descending: [ OK ] 0.36 sec. 2025-03-05 14:09:40 00034_fixed_string_to_number: [ OK ] 0.44 sec. 2025-03-05 14:09:40 00033_fixed_string_to_string: [ OK ] 0.52 sec. 2025-03-05 14:09:41 00023_agg_select_agg_subquery: [ OK ] 0.46 sec. 2025-03-05 14:09:41 00411_long_accurate_number_comparison_int1: [ OK ] 85.26 sec. 2025-03-05 14:09:41 00017_in_subquery_with_empty_result: [ OK ] 0.44 sec. 2025-03-05 14:09:41 00010_big_array_join: [ OK ] 0.42 sec. 2025-03-05 14:09:42 00003_reinterpret_as_string: [ OK ] 0.49 sec. 2025-03-05 14:09:42 2025-03-05 14:09:42 174 tests passed. 2 tests skipped. 688.32 s elapsed (ForkPoolWorker-8). 2025-03-05 14:09:42 00001_select_1: [ OK ] 0.45 sec. 2025-03-05 14:09:42 2025-03-05 14:09:42 96 tests passed. 0 tests skipped. 688.48 s elapsed (ForkPoolWorker-2). 2025-03-05 14:09:46 00376_shard_group_uniq_array_of_int_array: [ OK ] 85.35 sec. 2025-03-05 14:09:46 2025-03-05 14:09:46 Having 1 errors! 184 tests passed. 1 tests skipped. 692.88 s elapsed (ForkPoolWorker-9). 2025-03-05 14:09:58 00186_very_long_arrays: [ OK ] 65.09 sec. 2025-03-05 14:09:58 2025-03-05 14:09:58 Having 1 errors! 136 tests passed. 3 tests skipped. 704.55 s elapsed (ForkPoolWorker-6). 2025-03-05 14:10:08 02286_quantile_tdigest_infinity: [ OK ] 564.53 sec. 2025-03-05 14:10:08 2025-03-05 14:10:08 49 tests passed. 0 tests skipped. 714.75 s elapsed (ForkPoolWorker-7). 2025-03-05 14:10:22 00312_position_case_insensitive_utf8: [ OK ] 104.86 sec. 2025-03-05 14:10:22 2025-03-05 14:10:22 Having 1 errors! 189 tests passed. 2 tests skipped. 728.96 s elapsed (ForkPoolWorker-5). 2025-03-05 14:10:27 00097_long_storage_buffer_race_condition: [ OK ] 62.93 sec. 2025-03-05 14:10:27 2025-03-05 14:10:27 185 tests passed. 2 tests skipped. 733.65 s elapsed (ForkPoolWorker-3). 2025-03-05 14:12:17 00155_long_merges: [ OK ] 202.75 sec. 2025-03-05 14:12:17 2025-03-05 14:12:17 94 tests passed. 1 tests skipped. 843.01 s elapsed (ForkPoolWorker-4). 2025-03-05 14:12:17 2025-03-05 14:12:17 Running 116 stateless tests (MainProcess). 2025-03-05 14:12:17 2025-03-05 14:12:17 03171_hashed_dictionary_short_circuit_bug_fix: [ OK ] 0.61 sec. 2025-03-05 14:12:18 03000_traverse_shadow_system_data_paths: [ OK ] 0.52 sec. 2025-03-05 14:12:18 02989_system_tables_metadata_version: [ OK ] 0.73 sec. 2025-03-05 14:12:26 02980_dist_insert_readonly_replica: [ OK ] 7.84 sec. 2025-03-05 14:12:35 02933_change_cache_setting_without_restart: [ OK ] 8.25 sec. 2025-03-05 14:12:38 02918_fuzzjson_table_function: [ OK ] 3.55 sec. 2025-03-05 14:12:39 02908_empty_named_collection: [ OK ] 0.38 sec. 2025-03-05 14:12:44 02888_replicated_merge_tree_creation: [ OK ] 5.31 sec. 2025-03-05 14:12:44 02867_create_user_ssh: [ OK ] 0.45 sec. 2025-03-05 14:12:46 02843_insertion_table_schema_infer: [ OK ] 1.61 sec. 2025-03-05 14:12:47 02842_truncate_database: [ OK ] 1.33 sec. 2025-03-05 14:12:50 02789_table_functions_errors: [ OK ] 2.45 sec. 2025-03-05 14:12:50 02775_show_columns_called_from_clickhouse: [ OK ] 0.55 sec. 2025-03-05 14:12:52 02726_async_insert_flush_queue: [ OK ] 1.52 sec. 2025-03-05 14:12:53 02703_row_policies_for_database_combination: [ OK ] 1.17 sec. 2025-03-05 14:12:55 02686_postgres_protocol_decimal_256: [ OK ] 1.55 sec. 2025-03-05 14:13:01 02566_ipv4_ipv6_binary_formats: [ OK ] 6.31 sec. 2025-03-05 14:13:03 02561_temporary_table_sessions: [ OK ] 1.39 sec. 2025-03-05 14:13:08 02504_regexp_dictionary_yaml_source: [ OK ] 5.25 sec. 2025-03-05 14:13:12 02503_insert_storage_snapshot: [ OK ] 3.92 sec. 2025-03-05 14:13:13 02496_storage_s3_profile_events: [ OK ] 1.61 sec. 2025-03-05 14:13:14 02495_s3_filter_by_file: [ OK ] 0.80 sec. 2025-03-05 14:13:15 02494_query_cache_exception_handling: [ OK ] 0.42 sec. 2025-03-05 14:13:34 02494_query_cache_user_isolation: [ OK ] 18.90 sec. 2025-03-05 14:13:34 02494_query_cache_bugs: [ OK ] 0.60 sec. 2025-03-05 14:13:35 02494_query_cache_min_query_duration: [ OK ] 0.47 sec. 2025-03-05 14:13:35 02494_query_cache_explain: [ OK ] 0.53 sec. 2025-03-05 14:13:36 02494_query_cache_compression: [ OK ] 0.54 sec. 2025-03-05 14:13:40 02482_capnp_list_of_structs: [ OK ] 3.72 sec. 2025-03-05 14:15:10 02455_one_row_from_csv_memory_usage: [ OK ] 90.10 sec. 2025-03-05 14:15:10 02422_allow_implicit_no_password: [ SKIPPED ] 0.00 sec. - not running for current build 2025-03-05 14:15:17 02421_record_errors_row_by_input_format: [ OK ] 7.63 sec. 2025-03-05 14:15:18 02417_json_object_each_row_format: [ OK ] 0.45 sec. 2025-03-05 14:15:18 02411_merge_tree_zero_max_read_buffer_size: [ OK ] 0.46 sec. 2025-03-05 14:15:18 02397_system_parts_race_condition_drop_rm: [ SKIPPED ] 0.00 sec. - disabled 2025-03-05 14:15:18 02396_system_parts_race_condition_rm: [ SKIPPED ] 0.00 sec. - disabled 2025-03-05 14:15:22 02377_quota_key: [ OK ] 3.27 sec. 2025-03-05 14:15:24 02364_window_view_segfault: [ OK ] 2.13 sec. 2025-03-05 14:15:24 02323_null_modifier_in_table_function: [ OK ] 0.52 sec. 2025-03-05 14:15:26 02311_system_zookeeper_insert_priv: [ OK ] 1.80 sec. 2025-03-05 14:15:27 02294_fp_seconds_profile: [ OK ] 0.34 sec. 2025-03-05 14:15:29 02293_test_zstd_window_log_max: [ OK ] 2.84 sec. 2025-03-05 14:15:33 02270_stdin_with_query_or_infile_data: [ OK ] 3.66 sec. 2025-03-05 14:15:34 02265_rename_join_ordinary_to_atomic: [ OK ] 0.46 sec. 2025-03-05 14:17:21 02265_test_dns_profile_events: [ OK ] 107.39 sec. 2025-03-05 14:17:26 02263_lazy_mark_load: [ OK ] 5.41 sec. 2025-03-05 14:17:31 02247_names_order_in_json_and_tskv: [ OK ] 4.46 sec. 2025-03-05 14:17:31 02244_column_names_in_shcmea_inference: [ OK ] 0.45 sec. 2025-03-05 14:18:03 02241_filesystem_cache_on_write_operations: [ OK ] 31.41 sec. 2025-03-05 14:18:04 02240_filesystem_query_cache: [ OK ] 0.57 sec. 2025-03-05 14:18:04 02168_avro_bug: [ OK ] 0.54 sec. 2025-03-05 14:18:14 02149_external_schema_inference: [ OK ] 9.74 sec. 2025-03-05 14:18:14 02103_sql_user_defined_functions_composition: [ OK ] 0.45 sec. 2025-03-05 14:18:30 02103_tsv_csv_custom_null_representation: [ OK ] 15.92 sec. 2025-03-05 14:18:38 02103_with_names_and_types_parallel_parsing: [ OK ] 7.69 sec. 2025-03-05 14:18:39 02098_sql_user_defined_functions_aliases: [ OK ] 0.42 sec. 2025-03-05 14:19:08 02030_capnp_format: [ OK ] 29.56 sec. 2025-03-05 14:19:11 01945_system_warnings: [ OK ] 2.89 sec. 2025-03-05 14:19:12 01915_create_or_replace_dictionary: [ OK ] 0.58 sec. 2025-03-05 14:19:18 01889_check_row_policy_defined_using_user_function: [ OK ] 6.55 sec. 2025-03-05 14:19:19 01821_table_comment: [ OK ] 0.49 sec. 2025-03-05 14:19:20 01785_dictionary_element_count: [ OK ] 1.00 sec. 2025-03-05 14:19:21 01766_hashed_dictionary_complex_key: [ OK ] 1.08 sec. 2025-03-05 14:19:23 01765_hashed_dictionary_simple_key: [ OK ] 1.84 sec. 2025-03-05 14:19:24 01760_system_dictionaries: [ OK ] 0.89 sec. 2025-03-05 14:19:24 01759_dictionary_unique_attribute_names: [ OK ] 0.69 sec. 2025-03-05 14:19:26 01753_direct_dictionary_simple_key: [ OK ] 1.52 sec. 2025-03-05 14:20:10 01747_system_session_log_long: [ OK ] 44.00 sec. 2025-03-05 14:20:11 01747_executable_pool_dictionary_implicit_key: [ OK ] 1.14 sec. 2025-03-05 14:20:12 01746_executable_pool_dictionary: [ OK ] 1.13 sec. 2025-03-05 14:20:17 01656_test_query_log_factories_info: [ OK ] 4.58 sec. 2025-03-05 14:20:18 01625_constraints_index_append: [ OK ] 0.89 sec. 2025-03-05 14:20:19 01602_show_create_view: [ OK ] 0.97 sec. 2025-03-05 14:20:29 01600_log_queries_with_extensive_info: [ OK ] 9.71 sec. 2025-03-05 14:20:32 01545_system_errors: [ OK ] 3.64 sec. 2025-03-05 14:20:36 01543_avro_deserialization_with_lc: [ OK ] 4.20 sec. 2025-03-05 14:20:40 01524_do_not_merge_across_partitions_select_final: [ OK ] 3.18 sec. 2025-03-05 14:20:41 01516_create_table_primary_key: [ OK ] 0.96 sec. 2025-03-05 14:20:44 01507_clickhouse_server_start_with_embedded_config: [ OK ] 3.10 sec. 2025-03-05 14:20:44 01494_storage_join_persistency: [ OK ] 0.60 sec. 2025-03-05 14:20:45 01493_storage_set_persistency: [ OK ] 0.56 sec. 2025-03-05 14:20:45 01474_executable_dictionary: [ SKIPPED ] 0.00 sec. - not running for current build 2025-03-05 14:20:46 01471_calculate_ttl_during_merge: [ OK ] 0.79 sec. 2025-03-05 14:20:47 01455_rank_correlation_spearman: [ OK ] 0.74 sec. 2025-03-05 14:21:16 01396_inactive_replica_cleanup_nodes_zookeeper: [ OK ] 29.29 sec. 2025-03-05 14:21:17 01383_remote_ambiguous_column_shard: [ OK ] 0.60 sec. 2025-03-05 14:21:17 01355_ilike: [ OK ] 0.86 sec. 2025-03-05 14:21:33 01318_long_unsuccessful_mutation_zookeeper: [ OK ] 15.41 sec. 2025-03-05 14:21:33 01293_system_distribution_queue: [ OK ] 0.53 sec. 2025-03-05 14:21:38 01280_ssd_complex_key_dictionary: [ OK ] 4.58 sec. 2025-03-05 14:21:51 01275_parallel_mv: [ OK ] 12.78 sec. 2025-03-05 14:21:52 01257_dictionary_mismatch_types: [ OK ] 1.00 sec. 2025-03-05 14:21:52 01254_dict_create_without_db: [ OK ] 0.59 sec. 2025-03-05 14:21:53 01251_dict_is_in_infinite_loop: [ OK ] 0.94 sec. 2025-03-05 14:21:54 01249_bad_arguments_for_bloom_filter: [ OK ] 0.73 sec. 2025-03-05 14:21:55 01232_extremes: [ OK ] 1.15 sec. 2025-03-05 14:23:15 01200_mutations_memory_consumption: [ OK ] 79.57 sec. 2025-03-05 14:23:35 01161_all_system_tables: [ OK ] 19.86 sec. 2025-03-05 14:23:37 01155_rename_move_materialized_view: [ OK ] 1.90 sec. 2025-03-05 14:23:37 01110_dictionary_layout_without_arguments: [ OK ] 0.47 sec. 2025-03-05 14:23:38 01103_distributed_product_mode_local_column_renames: [ OK ] 1.03 sec. 2025-03-05 14:24:32 01079_parallel_alter_add_drop_column_zookeeper: [ OK ] 53.59 sec. 2025-03-05 14:26:10 01079_parallel_alter_modify_zookeeper_long: [ OK ] 98.05 sec. 2025-03-05 14:26:12 01078_window_view_alter_query_watch: [ OK ] 2.33 sec. 2025-03-05 14:26:21 01072_window_view_multiple_columns_groupby: [ OK ] 8.27 sec. 2025-03-05 14:26:22 01065_window_view_event_hop_watch_bounded: [ OK ] 1.52 sec. 2025-03-05 14:26:24 01062_window_view_event_hop_watch_asc: [ OK ] 1.64 sec. 2025-03-05 14:26:28 01053_ssd_dictionary: [ OK ] 4.24 sec. 2025-03-05 14:26:37 01042_system_reload_dictionary_reloads_completely: [ OK ] 9.11 sec. 2025-03-05 14:26:38 01036_no_superfluous_dict_reload_on_create_database_2: [ OK ] 0.73 sec. 2025-03-05 14:26:40 01018_dictionaries_from_dictionaries: [ OK ] 1.52 sec. 2025-03-05 14:26:51 01003_kill_query_race_condition: [ OK ] 11.23 sec. 2025-03-05 14:26:52 00985_merge_stack_overflow: [ OK ] 0.73 sec. 2025-03-05 14:26:53 00950_dict_get: [ OK ] 1.68 sec. 2025-03-05 14:26:58 00933_test_fix_extra_seek_on_compressed_cache: [ OK ] 5.08 sec. 2025-03-05 14:27:00 00510_materizlized_view_and_deduplication_zookeeper: [ OK ] 1.66 sec. 2025-03-05 14:27:00 2025-03-05 14:27:00 112 tests passed. 4 tests skipped. 883.54 s elapsed (MainProcess). 2025-03-05 14:27:06 Won't run stateful tests because test data wasn't loaded. 2025-03-05 14:27:06 Checking the hung queries: done 2025-03-05 14:27:06 2025-03-05 14:27:06 No queries hung. 2025-03-05 14:27:06 All tests have finished. 2025-03-05 14:27:06 2025-03-05 14:27:06 Top patterns of log messages: 2025-03-05 14:27:06 2025-03-05 14:27:06 count count_% size size_% uniq_loggers uniq_threads levels background_% message_format_string 2025-03-05 14:27:06 2025-03-05 14:27:06 1. 37359 0.051 2.16 MiB 0.011 24 493 ['Trace'] 0.002 Access granted: {}{} 2025-03-05 14:27:06 2. 33740 0.046 8.75 MiB 0.045 1 168 ['Debug'] 0 (from {}{}{}){}{} {} (stage: {}) 2025-03-05 14:27:06 3. 33726 0.046 5.06 MiB 0.026 4 167 ['Trace'] 1 {} Creating query context from {} context, user_id: {}, parent context user: {} 2025-03-05 14:27:06 4. 27295 0.037 770.17 KiB 0.004 1 166 ['Debug'] 0 Processed in {} sec. 2025-03-05 14:27:06 5. 21937 0.03 57.43 MiB 0.292 1 284 ['Trace'] 0.004 Query {} to stage {}{} 2025-03-05 14:27:06 6. 21762 0.029 57.86 MiB 0.294 1 284 ['Trace'] 0.004 Query {} from stage {} to stage {}{} 2025-03-05 14:27:06 7. 21705 0.029 1.51 MiB 0.008 1 1545 ['Trace'] 0.287 Reserved {} on local disk {}, having unreserved {}. 2025-03-05 14:27:06 8. 21703 0.029 978.46 KiB 0.005 1 1 ['Trace'] 1 Processing requests batch, size: {}, bytes: {} 2025-03-05 14:27:06 9. 20574 0.028 2.80 MiB 0.014 1 2 ['Trace'] 1 Creating part at path {} 2025-03-05 14:27:06 10. 20441 0.028 1.79 MiB 0.009 1 1036 ['Trace'] 0 Aggregated. {} to {} rows (from {}) in {} sec. ({:.3f} rows/sec., {}/sec.) 2025-03-05 14:27:06 11. 17965 0.024 2.15 MiB 0.011 723 686 ['Trace'] 0.216 Renaming temporary part {} to {} with tid {}. 2025-03-05 14:27:06 12. 17563 0.024 1.37 MiB 0.007 1 139 ['Debug'] 0 Read {} rows, {} in {} sec., {} rows/sec., {}/sec. 2025-03-05 14:27:06 13. 17327 0.023 1.17 MiB 0.006 724 1099 ['Trace'] 0.309 Trying to reserve {} using storage policy from min volume index {} 2025-03-05 14:27:06 14. 16593 0.022 496.47 KiB 0.002 1 1036 ['Trace'] 0 Aggregation method: {} 2025-03-05 14:27:06 15. 16281 0.022 812.35 KiB 0.004 1 660 ['Trace'] 0.147 filled checksums {} 2025-03-05 14:27:06 16. 12765 0.017 1.03 MiB 0.005 6 261 ['Debug'] 0.992 {} Authenticating user '{}' from {} 2025-03-05 14:27:06 17. 12507 0.017 1.37 MiB 0.007 6 261 ['Debug'] 0.992 {} Authenticated with global context as user {} 2025-03-05 14:27:06 18. 12479 0.017 1.07 MiB 0.005 6 259 ['Debug'] 0.992 {} Logout, user_id: {} 2025-03-05 14:27:06 19. 12377 0.017 1.32 MiB 0.007 4 167 ['Debug'] 1 {} Creating session context with user_id: {} 2025-03-05 14:27:06 20. 12127 0.016 1.23 MiB 0.006 1 26 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part, column {} 2025-03-05 14:27:06 21. 11605 0.016 124.66 KiB 0.001 1 1036 ['Trace'] 0 Aggregating 2025-03-05 14:27:06 22. 11219 0.015 534.01 KiB 0.003 1 161 ['Debug'] 0.205 Peak memory usage{}: {}. 2025-03-05 14:27:06 23. 10875 0.015 885.81 KiB 0.004 1 1009 ['Trace'] 0 An entry for key={} found in cache: sum_of_sizes={}, median_size={} 2025-03-05 14:27:06 24. 8931 0.012 810.74 KiB 0.004 91 500 ['Trace'] 0.999 Insert entry {} to queue with type {} 2025-03-05 14:27:06 25. 8729 0.012 712.98 KiB 0.004 102 1047 ['Trace'] 0.978 Part {} is not stored on zero-copy replicated disk, blobs can be removed 2025-03-05 14:27:06 26. 8481 0.011 706.56 KiB 0.004 541 130 ['Trace'] 0.001 Reading {} ranges in{}order from part {}, approx. {} rows starting from {} 2025-03-05 14:27:06 27. 8121 0.011 797.16 KiB 0.004 1 63 ['Debug'] 0 Reading {} marks from part {}, total {} rows starting from the beginning of the part 2025-03-05 14:27:06 28. 7859 0.011 1.44 MiB 0.007 2 100 ['Trace'] 1 HTTP Request for {}. Method: {}, Address: {}, User-Agent: {}{}, Content Type: {}, Transfer Encoding: {}, X-Forwarded-For: {} 2025-03-05 14:27:06 29. 7850 0.011 3.83 MiB 0.019 2 100 ['Trace'] 1 Request URI: {} 2025-03-05 14:27:06 30. 7619 0.01 156.25 KiB 0.001 2 100 ['Debug'] 0.197 Done processing query 2025-03-05 14:27:06 31. 6270 0.008 606.17 KiB 0.003 1 167 ['Debug'] 1 Connected {} version {}.{}.{}, revision: {}{}{}. 2025-03-05 14:27:06 32. 6270 0.008 205.69 KiB 0.001 2 167 ['Trace'] 1 TCP Request. Address: {} 2025-03-05 14:27:06 33. 6205 0.008 163.61 KiB 0.001 1 163 ['Debug'] 1 Done processing connection. 2025-03-05 14:27:06 34. 5549 0.008 401.26 KiB 0.002 74 137 ['Debug'] 0 Wrote block with ID '{}', {} rows{} 2025-03-05 14:27:06 35. 4902 0.007 172.36 KiB 0.001 1 16 ['Trace'] 1 Keeper request. Address: {} 2025-03-05 14:27:06 36. 4523 0.006 141.34 KiB 0.001 1 15 ['Debug'] 1 Receive four letter command {} 2025-03-05 14:27:06 37. 3580 0.005 80.41 KiB 0 1 990 ['Trace'] 0 Merging aggregated data 2025-03-05 14:27:06 38. 3556 0.005 175.54 KiB 0.001 1 153 ['Trace'] 0 Merging partially aggregated blocks (bucket = {}). 2025-03-05 14:27:06 39. 3556 0.005 537.15 KiB 0.003 1 153 ['Debug'] 0 Merged partially aggregated blocks for bucket #{}. Got {} rows, {} from {} source rows in {} sec. ({:.3f} rows/sec., {}/sec.) 2025-03-05 14:27:06 40. 3402 0.005 262.46 KiB 0.001 1 121 ['Trace'] 0 Query span trace_id for opentelemetry log: {} 2025-03-05 14:27:06 41. 3225 0.004 637.07 KiB 0.003 1 512 ['Information'] 1 Removing metadata {} of dropped table {} 2025-03-05 14:27:06 42. 3225 0.004 408.77 KiB 0.002 1 512 ['Information'] 1 Have {} tables in drop queue ({} of them are in use), will try drop {} 2025-03-05 14:27:06 43. 3212 0.004 238.39 KiB 0.001 1 86 ['Debug'] 0 Waiting for table {} to be finally dropped 2025-03-05 14:27:06 44. 3075 0.004 460.41 KiB 0.002 1 779 ['Information'] 0 Done writing part of data into temporary file {}, compressed {}, uncompressed {} 2025-03-05 14:27:06 45. 3075 0.004 348.34 KiB 0.002 1 805 ['Information'] 0 Sorting and writing part of data into temporary file {} 2025-03-05 14:27:06 46. 2819 0.004 114.61 KiB 0.001 70 33 ['Debug'] 0.525 Committing part {} to zookeeper 2025-03-05 14:27:06 47. 2819 0.004 76.70 KiB 0 610 176 ['Debug'] 0.028 Key condition: {} 2025-03-05 14:27:06 48. 2731 0.004 355.41 KiB 0.002 1 59 ['Debug'] 0.001 Before join block: '{}' 2025-03-05 14:27:06 49. 2731 0.004 495.97 KiB 0.002 1 59 ['Debug'] 0.001 After join block: '{}' 2025-03-05 14:27:06 50. 2637 0.004 302.29 KiB 0.002 605 176 ['Debug'] 0.03 Selected {}/{} parts by partition key, {} parts by primary key, {}/{} marks by primary key, {} marks to read from {} ranges 2025-03-05 14:27:06 51. 2621 0.004 103.82 KiB 0.001 69 32 ['Debug'] 0.564 Part {} committed to zookeeper 2025-03-05 14:27:06 52. 2618 0.004 282.99 KiB 0.001 9 503 ['Trace'] 1 Cannot execute alter metadata {} with version {} because another alter {} must be executed before 2025-03-05 14:27:06 53. 2550 0.003 22.41 KiB 0 2 91 ['Trace'] 0.002 No tables 2025-03-05 14:27:06 54. 2542 0.003 52.13 KiB 0 1 893 ['Debug'] 1 Stop worker in {} 2025-03-05 14:27:06 55. 2542 0.003 166.50 KiB 0.001 1 683 ['Debug'] 1 Execute load job '{}' in {} 2025-03-05 14:27:06 56. 2542 0.003 176.43 KiB 0.001 1 683 ['Debug'] 1 Finish load job '{}' with status {} 2025-03-05 14:27:06 57. 2542 0.003 173.95 KiB 0.001 1 91 ['Debug'] 0.002 Schedule load job '{}' into {} 2025-03-05 14:27:06 58. 2542 0.003 79.44 KiB 0 1 769 ['Debug'] 0.499 Spawn loader worker #{} in {} 2025-03-05 14:27:06 59. 2541 0.003 201.19 KiB 0.001 1 91 ['Debug'] 0.002 Prioritize load job '{}': {} -> {} 2025-03-05 14:27:06 60. 2534 0.003 84.14 KiB 0 1 767 ['Debug'] 0.501 Change current priority: {} -> {} 2025-03-05 14:27:06 61. 2523 0.003 145.49 KiB 0.001 89 499 ['Debug'] 0.999 Pulling {} entries to queue: {} - {} 2025-03-05 14:27:06 62. 2523 0.003 64.18 KiB 0 89 499 ['Debug'] 0.999 Pulled {} entries to queue. 2025-03-05 14:27:06 63. 2438 0.003 218.27 KiB 0.001 1 887 ['Debug'] 0 Merge sorted {} blocks, {} rows in {} sec., {} rows/sec., {}/sec 2025-03-05 14:27:06 64. 2353 0.003 252.95 KiB 0.001 1 83 ['Trace'] 0.033 PREWHERE condition was split into {} steps: {} 2025-03-05 14:27:06 65. 2343 0.003 136.35 KiB 0.001 15 15 ['Trace'] 1 Flushing system log, {} entries to flush up to offset {} 2025-03-05 14:27:06 66. 2343 0.003 84.62 KiB 0 15 15 ['Trace'] 1 Flushed system log up to offset {} 2025-03-05 14:27:06 67. 2299 0.003 118.99 KiB 0.001 534 170 ['Trace'] 0.033 Spreading mark ranges among streams (default reading) 2025-03-05 14:27:06 68. 2207 0.003 188.51 KiB 0.001 162 499 ['Trace'] 1 Scheduling next merge selecting task after {}ms, current attempt status: {} 2025-03-05 14:27:06 69. 2162 0.003 301.25 KiB 0.001 94 480 ['Trace'] 1 Checked {} partitions, found {} partitions with parts that may be merged: [{}] (max_total_size_to_merge={}, merge_with_ttl_allowed={}) 2025-03-05 14:27:06 70. 2068 0.003 164.87 KiB 0.001 1 851 ['Trace'] 0 Statistics updated for key={}: new sum_of_sizes={}, median_size={} 2025-03-05 14:27:06 71. 1976 0.003 103.62 KiB 0.001 208 523 ['Debug'] 0.815 Selected {} parts from {} to {} 2025-03-05 14:27:06 72. 1736 0.002 143.09 KiB 0.001 1 65 ['Debug'] 0 Merging {} parts: from {} to {} into {} with storage {} 2025-03-05 14:27:06 73. 1736 0.002 58.85 KiB 0 1 65 ['Debug'] 0 Selected MergeAlgorithm: {} 2025-03-05 14:27:06 74. 1731 0.002 224.09 KiB 0.001 1 65 ['Debug'] 0 Merge sorted {} rows, containing {} columns ({} merged, {} gathered) in {} sec., {} rows/sec., {}/sec. 2025-03-05 14:27:06 75. 1729 0.002 111.74 KiB 0.001 214 65 ['Trace'] 0 Merged {} parts: [{}, {}] -> {} 2025-03-05 14:27:06 76. 1617 0.002 67.91 KiB 0 1 803 ['Information'] 0 There are {} temporary sorted parts to merge 2025-03-05 14:27:06 77. 1610 0.002 28.30 KiB 0 1520 135 ['Debug'] 0.034 Loading data parts 2025-03-05 14:27:06 78. 1571 0.002 35.29 KiB 0 1520 119 ['Debug'] 0.025 There are no data parts 2025-03-05 14:27:06 79. 1544 0.002 188.54 KiB 0.001 1 2 ['Trace'] 1 MemoryTracking: was {}, peak {}, free memory in arenas {}, will set to {} (RSS), difference: {} 2025-03-05 14:27:06 80. 1517 0.002 87.53 KiB 0 1495 486 ['Trace'] 0.976 dropAllData: removing data parts (count {}) from filesystem. 2025-03-05 14:27:06 81. 1517 0.002 114.07 KiB 0.001 1495 486 ['Information'] 0.976 dropAllData: remove format_version.txt, detached, moving and write ahead logs 2025-03-05 14:27:06 82. 1517 0.002 72.59 KiB 0 1495 486 ['Trace'] 0.976 dropAllData: removing all data parts from memory. 2025-03-05 14:27:06 83. 1517 0.002 97.78 KiB 0 1495 486 ['Information'] 0.976 dropAllData: removing table directory recursive to cleanup garbage 2025-03-05 14:27:06 84. 1517 0.002 45.92 KiB 0 1495 486 ['Trace'] 0.976 dropAllData: waiting for locks. 2025-03-05 14:27:06 85. 1517 0.002 26.67 KiB 0 1495 486 ['Trace'] 0.976 dropAllData: done. 2025-03-05 14:27:06 86. 1517 0.002 63.70 KiB 0 1495 486 ['Information'] 0.976 dropAllData: clearing temporary directories 2025-03-05 14:27:06 87. 1514 0.002 130.11 KiB 0.001 40 33 ['Trace'] 0.985 Trying to fetch with zero-copy replication, but disk is not provided, will try to select 2025-03-05 14:27:06 88. 1514 0.002 54.71 KiB 0 40 33 ['Trace'] 0.985 Checking disk {} with type {} 2025-03-05 14:27:06 89. 1511 0.002 213.63 KiB 0.001 40 31 ['Debug'] 0.985 Fetching part {} from {}:{} 2025-03-05 14:27:06 90. 1503 0.002 29.14 KiB 0 40 33 ['Debug'] 0.985 Downloading files {} 2025-03-05 14:27:06 91. 1503 0.002 70.61 KiB 0 40 33 ['Debug'] 0.985 Downloading part {} onto disk {}. 2025-03-05 14:27:06 92. 1503 0.002 127.70 KiB 0.001 40 33 ['Trace'] 0.985 Disk for fetch is not provided, getting disk from reservation {} with type '{}' 2025-03-05 14:27:06 93. 1503 0.002 83.82 KiB 0 40 33 ['Debug'] 0.985 Download of part {} onto disk {} finished. 2025-03-05 14:27:06 94. 1503 0.002 36.85 KiB 0 40 31 ['Trace'] 1 Sending part {} 2025-03-05 14:27:06 95. 1500 0.002 210.84 KiB 0.001 40 31 ['Debug'] 0.985 Fetched part {} from {}:{}{} 2025-03-05 14:27:06 96. 1345 0.002 75.75 KiB 0 27 93 ['Trace'] 0.948 List of all grants: {} 2025-03-05 14:27:06 97. 1345 0.002 102.45 KiB 0.001 27 93 ['Trace'] 0.948 Settings: readonly = {}, allow_ddl = {}, allow_introspection_functions = {} 2025-03-05 14:27:06 98. 1345 0.002 169.60 KiB 0.001 27 93 ['Trace'] 0.948 List of all grants including implicit: {} 2025-03-05 14:27:06 99. 1275 0.002 104.69 KiB 0.001 1266 91 ['Information'] 0.002 Metadata processed, database {} has {} tables and {} dictionaries in total. 2025-03-05 14:27:06 100. 1275 0.002 75.80 KiB 0 1 91 ['Information'] 0.002 Parsed metadata of {} tables in {} databases in {} sec 2025-03-05 14:27:06 2025-03-05 14:27:06 2025-03-05 14:27:06 2025-03-05 14:27:06 Top messages without format string (fmt::runtime): 2025-03-05 14:27:06 2025-03-05 14:27:06 count pattern runtime_message line 2025-03-05 14:27:06 2025-03-05 14:27:06 1. 67 DBExceptionThereisnouserinvalids DB::Exception: There is no user `invalid_session_log_test_xml_user` in user directories ('',0) 2025-03-05 14:27:06 2. 66 Connectiontomysqlfailedtimes Connection to mysql failed 1 times ('',0) 2025-03-05 14:27:06 3. 39 Connectiontosystemasuserinvalids Connection to system@127.0.0.1:9004 as user invalid_session_log_test_xml_user failed: mysqlxx::ConnectionFailed: There is no user `invalid_session_log_test_xml_user` in user directories ((nullptr):9004) ('',0) 2025-03-05 14:27:06 4. 39 DBExceptionsessionlogtestuserabc DB::Exception: session_log_test_user_a5162b4cf315108972343a4e8bb4a5f8_plaintext_password_no_profiles_no_roles: Authentication failed: password is incorrect, or there is no user with such name. ('',0) 2025-03-05 14:27:06 5. 27 Connectiontosystemasusersessionl Connection to system@127.0.0.1:9004 as user session_log_test_user_a5162b4cf315108972343a4e8bb4a5f8_plaintext_password_no_profiles_no_roles failed: mysqlxx::ConnectionFailed: session_log_test_user_a5162b4cf315108972343a4e8bb4a5f8_plaintext_password_no_profi ('',0) 2025-03-05 14:27:06 6. 16 CodeDBExceptionReceivedfromDBExc Code: 395. DB::Exception: Received from 127.2:9000. DB::Exception: Value passed to 'throwIf' function is non-zero: while executing 'FUNCTION throwIf(not(__table1.dummy) :: 0) -> throwIf(not(__table1.dummy)) UInt8 : 2'. Stack trace: 2025-03-05 14:27:06 2025-03-05 14:27:06 0. ./contrib/llvm-proje ('/executeQuery.cpp',218) 2025-03-05 14:27:06 7. 7 PocoExceptionCodeecodeNetExcepti Poco::Exception. Code: 1000, e.code() = 107, Net Exception: Socket is not connected, Stack trace (when copying this message, always include the lines below): 2025-03-05 14:27:06 2025-03-05 14:27:06 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, ('/Exception.cpp',222) 2025-03-05 14:27:06 8. 6 CodeDBExceptionSyntaxerrorfailed Code: 62. DB::Exception: Syntax error: failed at position 8 ('$'): $$ab 2025-03-05 14:27:06 . Expected one of: ALL, DISTINCT ON, DISTINCT, TOP, not empty list of expressions, list of expressions, list of elements, expression with optional alias, element of expression with opt ('/executeQuery.cpp',218) 2025-03-05 14:27:06 9. 6 CodeDBExceptionReceivedfromlocal Code: 242. DB::Exception: Received from localhost:9000. DB::Exception: Table is in readonly mode: replica_path=/tables/shard_1/data/replicas/read. Stack trace: 2025-03-05 14:27:06 2025-03-05 14:27:06 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const ('/executeQuery.cpp',218) 2025-03-05 14:27:06 10. 4 CodeDBExceptionFailedtogetobject Code: 499. DB::Exception: Failed to get object info: No response body.. HTTP response code: 404: While executing S3. (S3_ERROR) (version 24.3.12.76.altinitystable) (from [::1]:45846) (comment: 02752_forbidden_headers.sql) (in query: SELECT * FROM s3('http: ('/executeQuery.cpp',218) 2025-03-05 14:27:06 11. 4 CodeDBExceptionSQLitedatabasefil Code: 481. DB::Exception: SQLite database file path '/etc/passwd' must be inside 'user_files' directory. (PATH_ACCESS_DENIED) (version 24.3.12.76.altinitystable) (from [::1]:57310) (comment: 02918_sqlite_path_check.sh) (in query: Select * from sqlite('/etc ('/executeQuery.cpp',218) 2025-03-05 14:27:06 12. 2 CodeDBExceptionNumberequalswhile Code: 395. DB::Exception: Number equals 1000: while executing 'FUNCTION throwIf(equals(__table1.number, 1000_UInt16) :: 0, 'Number equals 1000'_String :: 2) -> throwIf(equals(__table1.number, 1000_UInt16), 'Number equals 1000'_String) UInt8 : 1'. (FUNCTION ('/executeQuery.cpp',218) 2025-03-05 14:27:06 13. 2 IfthesignaturecheckfailedThiscou If the signature check failed. This could be because of a time skew. Attempting to adjust the signer. ('/AWSLogger.cpp',71) 2025-03-05 14:27:06 14. 1 Electiontimeoutinitiateleaderele Election timeout, initiate leader election ('/LoggerWrapper.h',43) 2025-03-05 14:27:06 15. 1 bgappendentriesthreadinitiated bg append_entries thread initiated ('/LoggerWrapper.h',43) 2025-03-05 14:27:06 16. 1 startingup starting up ('',0) 2025-03-05 14:27:06 17. 1 newconfigurationlogidxprevlogidx new configuration: log idx 1, prev log idx 0 2025-03-05 14:27:06 peer 1, DC ID 0, localhost:9234, voting member, 1 2025-03-05 14:27:06 my id: 1, leader: 1, term: 1 ('/LoggerWrapper.h',43) 2025-03-05 14:27:06 18. 1 invalidelectiontimeoutupperbound invalid election timeout upper bound detected, adjusted to 0 ('/LoggerWrapper.h',43) 2025-03-05 14:27:06 19. 1 statemachinecommitindexprecommit state machine commit index 0, precommit index 0, last log index 0 ('/LoggerWrapper.h',43) 2025-03-05 14:27:06 20. 1 Forkedachildprocesstowatch Forked a child process to watch ('',0) 2025-03-05 14:27:06 21. 1 PocoExceptionCodeecodeNotfoundbo Poco::Exception. Code: 1000, e.code() = 0, Not found: boundary, Stack trace (when copying this message, always include the lines below): 2025-03-05 14:27:06 2025-03-05 14:27:06 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001d1 ('/Exception.cpp',222) 2025-03-05 14:27:06 22. 1 waitforHBforms wait for HB, for 50 + [0, 0] ms ('/LoggerWrapper.h',43) 2025-03-05 14:27:06 23. 1 INITRAFTSERVERcommitindextermele === INIT RAFT SERVER === 2025-03-05 14:27:06 commit index 0 2025-03-05 14:27:06 term 0 2025-03-05 14:27:06 election timer allowed 2025-03-05 14:27:06 log store start 1, end 0 2025-03-05 14:27:06 config log idx 0, prev log idx 0 2025-03-05 14:27:06 -- ASYNC REPLICATION -- ('/LoggerWrapper.h',43) 2025-03-05 14:27:06 24. 1 newconfiglogidxprevlogidxcurconf new config log idx 1, prev log idx 0, cur config log idx 0, prev log idx 0 ('/LoggerWrapper.h',43) 2025-03-05 14:27:06 25. 1 ELECTIONTIMEOUTcurrentrolefollow [ELECTION TIMEOUT] current role: follower, log last term 0, state term 0, target p 1, my p 1, hb dead, pre-vote NOT done ('/LoggerWrapper.h',43) 2025-03-05 14:27:06 26. 1 globalmanagerdoesnotexistwilluse global manager does not exist. will use local thread for commit and append ('/LoggerWrapper.h',43) 2025-03-05 14:27:06 27. 1 configatindexiscommittedprevconf config at index 1 is committed, prev config log idx 0 ('/LoggerWrapper.h',43) 2025-03-05 14:27:06 28. 1 PRIORITYdecaytargetmine [PRIORITY] decay, target 1 -> 1, mine 1 ('/LoggerWrapper.h',43) 2025-03-05 14:27:06 29. 1 newelectiontimeoutrange new election timeout range: 0 - 0 ('/LoggerWrapper.h',43) 2025-03-05 14:27:24 30. 1 BECOMELEADERappendednewconfigat [BECOME LEADER] appended new config at 1 ('/LoggerWrapper.h',43) 2025-03-05 14:27:24 2025-03-05 14:27:24 2025-03-05 14:27:24 2025-03-05 14:27:24 Top messages not matching their format strings: 2025-03-05 14:27:24 2025-03-05 14:27:24 message_format_string count() any_message 2025-03-05 14:27:24 2025-03-05 14:27:24 1. 158 Connection to system@127.0.0.1:9004 as user invalid_session_log_test_xml_user failed: mysqlxx::ConnectionFailed: There is no user `invalid_session_log_test_xml_user` in user directories ((nullptr):9004) 2025-03-05 14:27:24 message_format_string count() any_message 2025-03-05 14:27:24 2025-03-05 14:27:24 2. {} is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) 26 /var/lib/clickhouse/store/ef4/ef4d0875-7300-45b0-8c93-d3e245ed66ab/tmp_merge_202503_50_77_5/ is in use (by merge/mutation/INSERT) (consider increasing temporary_directories_lifetime setting) (skipped 1 similar messages) 2025-03-05 14:27:24 message_format_string count() any_message 2025-03-05 14:27:24 2025-03-05 14:27:24 3. Query {} to stage {}{} 2 Query SELECT IPv6CIDRToRange(_CAST(' \r�\0\0��\0\0\0\0��', 'FixedString(16)'), toUInt8(128 - __table1.number)) AS `IPv6CIDRToRange(IPv6StringToNum('2001:0db8:0000:85a3:0000:0000:ac1f:8001'), toUInt8(minus(128, number)))` FROM numbers(2) AS __table1 to stage Complete 2025-03-05 14:27:24 message_format_string count() any_message 2025-03-05 14:27:24 2025-03-05 14:27:24 4. Query {} from stage {} to stage {}{} 2 Query SELECT IPv6CIDRToRange(_CAST(' \r�\0\0��\0\0\0\0��', 'FixedString(16)'), toUInt8(128 - __table1.number)) AS `IPv6CIDRToRange(IPv6StringToNum('2001:0db8:0000:85a3:0000:0000:ac1f:8001'), toUInt8(minus(128, number)))` FROM numbers(2) AS __table1 from stage FetchColumns to stage Complete 2025-03-05 14:27:24 2025-03-05 14:27:24 2025-03-05 14:27:24 2025-03-05 14:27:24 Top short messages: 2025-03-05 14:27:24 2025-03-05 14:27:24 c message_format_string substr(any(message), 1, 120) min_length_without_exception_boilerplate 2025-03-05 14:27:24 2025-03-05 14:27:24 1. 71 {}:{}: '{}' src/Processors/Transforms/MergeJoinTransform.cpp:836: ' UInt64(size = 1) String(size = 1) UInt64(size = 1) Int64(size = 62 2025-03-05 14:27:24 c message_format_string substr(any(message), 1, 120) min_length_without_exception_boilerplate 2025-03-05 14:27:24 2025-03-05 14:27:24 2. 6 Bad SSH public key provided Code: 706. DB::Exception: Bad SSH public key provided. (LIBSSH_ERROR) (version 24.3.12.76.altinitystable) (from [::1]:49 29 2025-03-05 14:27:24 c message_format_string substr(any(message), 1, 120) min_length_without_exception_boilerplate 2025-03-05 14:27:24 2025-03-05 14:27:24 3. 5 {} Server was built with sanitizer. It will work slowly. 27 2025-03-05 14:27:24 c message_format_string substr(any(message), 1, 120) min_length_without_exception_boilerplate 2025-03-05 14:27:24 2025-03-05 14:27:24 4. 2 Path to archive is empty Code: 36. DB::Exception: Path to archive is empty. (BAD_ARGUMENTS) (version 24.3.12.76.altinitystable) (from [::1]:54720 25 2025-03-05 14:27:24 c message_format_string substr(any(message), 1, 120) min_length_without_exception_boilerplate 2025-03-05 14:27:24 2025-03-05 14:27:24 5. 1 Froze {} parts Froze 1 parts -13 2025-03-05 14:27:24 2025-03-05 14:27:24 2025-03-05 14:27:24 2025-03-05 14:27:24 Top messages by level: 2025-03-05 14:27:24 2025-03-05 14:27:24 (0.0009449415841986272,'Table {}.{} does not exist. Maybe you meant {}.{}?') Error 2025-03-05 14:27:24 (0.0005090229737230428,'Not enabled four letter command {}') Warning 2025-03-05 14:27:24 (0.004365955027278758,'Removing metadata {} of dropped table {}') Information 2025-03-05 14:27:24 (0.04568210432263392,'(from {}{}{}){}{} {} (stage: {})') Debug 2025-03-05 14:27:24 (0.050582804229222796,'Access granted: {}{}') Trace 2025-03-05 14:27:24 2025-03-05 14:27:24